﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Model;
using Utility;
namespace Service
{
    /// <summary>
    /// 功能：HW_Result2013类数据访问
    /// 创建人：Wilson
    /// 创建时间：2013-1-30   
    /// </summary>
    public class HW_Result2013Service : IDisposable
    {
        #region 公共
        private System.ComponentModel.Component component = new System.ComponentModel.Component();

        private bool disposed = false;

        ~HW_Result2013Service()
        {
            Dispose(false);
        }

        #endregion

        #region IDisposable 成员

        public void Dispose()
        {
            Dispose(true);
            GC.SuppressFinalize(this);
        }

        private void Dispose(bool disposing)
        {
            if (!this.disposed)
            {

                if (disposing)
                {

                    component.Dispose();
                }

                disposed = true;

            }
        }
        #endregion
		#region##MapperHW_Result2013
        public IList<HW_Result2013> MapperList(SqlDataReader reader)
         {
            IList<HW_Result2013> list = new List<HW_Result2013>();
            HW_Result2013 obj=null;
            while (reader.Read())
            {
                obj = new HW_Result2013();
                obj.TJND = (string)reader["TJND"];
                obj.BH = (string)reader["BH"];
                obj.CHECKID = (decimal)reader["CHECKID"];
                obj.SCHOOLBH = (string)reader["SCHOOLBH"];
                obj.GRADEBH = (string)reader["GRADEBH"];
                obj.CLASSBH = (string)reader["CLASSBH"];
                obj.RXSJ = reader["RXSJ"] as string;
                obj.XH = reader["XH"] as string;
                obj.SCHOOL_NAME = reader["SCHOOL_NAME"] as string;
                obj.GRADE_NAME = reader["GRADE_NAME"] as string;
                obj.CLASS_NAME = reader["CLASS_NAME"] as string;
                obj.XM = reader["XM"] as string;
                obj.XB = (string)reader["XB"];
                obj.CSRQ = (DateTime)reader["CSRQ"];
                obj.MZ = reader["MZ"] as string;
                obj.ZZMM = reader["ZZMM"] as string;
                obj.SY = reader["SY"] as string;
                obj.TJRQ = reader["TJRQ"] as DateTime?;
                obj.NL = reader["NL"] as int?;
                obj.MARK = reader["MARK"] as string;
                obj.SG = reader["SG"] as decimal?;
                obj.SGDJQ = reader["SGDJQ"] as string;
                obj.SGDJD = reader["SGDJD"] as string;
                obj.SGBJ = reader["SGBJ"] as string;
                obj.TZ = reader["TZ"] as decimal?;
                obj.TZDJQ = reader["TZDJQ"] as string;
                obj.TZDJD = reader["TZDJD"] as string;
                obj.TZBJ = reader["TZBJ"] as string;
                obj.YYPJ = reader["YYPJ"] as string;
                obj.YYPJX = reader["YYPJX"] as string;
                obj.TXPJ = reader["TXPJ"] as string;
                obj.FYPJ = reader["FYPJ"] as string;
                obj.XW = reader["XW"] as decimal?;
                obj.XWDJQ = reader["XWDJQ"] as string;
                obj.XWDJD = reader["XWDJD"] as string;
                obj.XWBJ = reader["XWBJ"] as string;
                obj.FHL = reader["FHL"] as decimal?;
                obj.FHLDJQ = reader["FHLDJQ"] as string;
                obj.FHLDJD = reader["FHLDJD"] as string;
                obj.FHLBJ = reader["FHLBJ"] as string;
                obj.WL = reader["WL"] as decimal?;
                obj.WLDJQ = reader["WLDJQ"] as string;
                obj.WLDJD = reader["WLDJD"] as string;
                obj.WLBJ = reader["WLBJ"] as string;
                obj.MB = reader["MB"] as decimal?;
                obj.MBBJ = reader["MBBJ"] as string;
                obj.SSY = reader["SSY"] as decimal?;
                obj.SSYBJ = reader["SSYBJ"] as string;
                obj.SZY = reader["SZY"] as decimal?;
                obj.SZYBJ = reader["SZYBJ"] as string;
                obj.LSL = reader["LSL"] as decimal?;
                obj.RSL = reader["RSL"] as decimal?;
                obj.QTYB = reader["QTYB"] as string;
                obj.LQG = reader["LQG"] as string;
                obj.RQG = reader["RQG"] as string;
                obj.LSY = reader["LSY"] as string;
                obj.RSY = reader["RSY"] as string;
                obj.BS = reader["BS"] as string;
                obj.TL = reader["TL"] as string;
                obj.XJ = reader["XJ"] as string;
                obj.BB = reader["BB"] as string;
                obj.QSBNUM = reader["QSBNUM"] as int?;
                obj.RQB = reader["RQB"] as int?;
                obj.RQS = reader["RQS"] as int?;
                obj.RQH = reader["RQH"] as int?;
                obj.HQB = reader["HQB"] as int?;
                obj.HQS = reader["HQS"] as int?;
                obj.HQH = reader["HQH"] as int?;
                obj.YZB = reader["YZB"] as string;
                obj.BTT = reader["BTT"] as string;
                obj.XK = reader["XK"] as string;
                obj.JZ = reader["JZ"] as string;
                obj.SZ = reader["SZ"] as string;
                obj.PZ = reader["PZ"] as string;
                obj.XZ = reader["XZ"] as string;
                obj.GP = reader["GP"] as string;
                obj.FEI = reader["FEI"] as string;
                obj.XT = reader["XT"] as string;
                obj.XHDB = reader["XHDB"] as int?;
                obj.FHCL = reader["FHCL"] as string;
                obj.PFB = reader["PFB"] as string;
                obj.ZG = reader["ZG"] as decimal?;
                obj.ZGDJQ = reader["ZGDJQ"] as string;
                obj.ZGDJD = reader["ZGDJD"] as string;
                obj.ZGBJ = reader["ZGBJ"] as string;
                obj.JK = reader["JK"] as decimal?;
                obj.JKDJQ = reader["JKDJQ"] as string;
                obj.JKDJD = reader["JKDJD"] as string;
                obj.JKBJ = reader["JKBJ"] as string;
                obj.GPK = reader["GPK"] as decimal?;
                obj.GPKDJQ = reader["GPKDJQ"] as string;
                obj.GPKDJD = reader["GPKDJD"] as string;
                obj.GPKBJ = reader["GPKBJ"] as string;
                obj.BJL = reader["BJL"] as decimal?;
                obj.GSTJ = reader["GSTJ"] as decimal?;
                obj.JJX = reader["JJX"] as decimal?;
                obj.BMKY = reader["BMKY"] as string;
                obj.SJSR = reader["SJSR"] as string;
                obj.WSM = reader["WSM"] as decimal?;
                obj.WSMDJQ = reader["WSMDJQ"] as string;
                obj.WSMDJD = reader["WSMDJD"] as string;
                obj.WSMBJ = reader["WSMBJ"] as string;
                obj.LDTY = reader["LDTY"] as decimal?;
                obj.LDTYDJQ = reader["LDTYDJQ"] as string;
                obj.LDTYDJD = reader["LDTYDJD"] as string;
                obj.LDTYBJ = reader["LDTYBJ"] as string;
                obj.LL = reader["LL"] as decimal?;
                obj.LLDJQ = reader["LLDJQ"] as string;
                obj.LLDJD = reader["LLDJD"] as string;
                obj.LLBJ = reader["LLBJ"] as string;
                obj.NNL = reader["NNL"] as decimal?;
                obj.NNLDJQ = reader["NNLDJQ"] as string;
                obj.NNLDJD = reader["NNLDJD"] as string;
                obj.NNLBJ = reader["NNLBJ"] as string;
                obj.ZWT = reader["ZWT"] as decimal?;
                obj.ZWTDJQ = reader["ZWTDJQ"] as string;
                obj.ZWTDJD = reader["ZWTDJD"] as string;
                obj.ZWTBJ = reader["ZWTBJ"] as string;
                obj.T1 = reader["T1"] as string;
                obj.T2 = reader["T2"] as string;
                obj.T3 = reader["T3"] as string;
                obj.T4 = reader["T4"] as string;
                obj.T5 = reader["T5"] as string;
                obj.T6 = reader["T6"] as string;
                obj.T7 = reader["T7"] as string;
                obj.T8 = reader["T8"] as string;
                obj.T9 = reader["T9"] as string;
                obj.T10 = reader["T10"] as string;
                obj.SLBH = reader["SLBH"] as string;
                obj.MBPJ = reader["MBPJ"] as string;
                obj.SSYPJ = reader["SSYPJ"] as string;
                obj.SZYPJ = reader["SZYPJ"] as string;
                obj.PXPJ = reader["PXPJ"] as string;
                obj.SLPJ = reader["SLPJ"] as string;
                obj.XJH = reader["XJH"] as string;
                obj.YYPJB = reader["YYPJB"] as string;
                obj.TJSY = reader["TJSY"] as int?;
                obj.MB1 = reader["MB1"] as int?;
                obj.MB2 = reader["MB2"] as int?;
                obj.MB3 = reader["MB3"] as int?;
                obj.TJFS = reader["TJFS"] as int?;
                obj.TJPJ = reader["TJPJ"] as string;
                obj.YYPJH = reader["YYPJH"] as string;
                obj.XMPY = reader["XMPY"] as string;
                obj.HXP = reader["HXP"] as decimal?;
                obj.HXPPJ = reader["HXPPJ"] as string;
                obj.EB = reader["EB"] as string;
                obj.YB = reader["YB"] as string;
                obj.TB = reader["TB"] as string;
                obj.JB = reader["JB"] as string;
                obj.PF = reader["PF"] as string;
                obj.JZX = reader["JZX"] as string;
                obj.LBJ = reader["LBJ"] as string;
                obj.JHJS = reader["JHJS"] as string;
                obj.GBZAM = reader["GBZAM"] as decimal?;
                obj.DHSA = reader["DHSA"] as decimal?;
                obj.DHSZ = reader["DHSZ"] as decimal?;
                obj.GG = reader["GG"] as string;
                obj.BMKT = reader["BMKT"] as string;
                obj.YGHKT = reader["YGHKT"] as string;
                obj.YGEKY = reader["YGEKY"] as string;
                obj.YGEKT = reader["YGEKT"] as string;
                obj.BLOOD = reader["BLOOD"] as string;
                obj.YW = reader["YW"] as decimal?;
                obj.TW = reader["TW"] as decimal?;
                obj.CXBH = reader["CXBH"] as string;
                obj.LJSL = reader["LJSL"] as decimal?;
                obj.RJSL = reader["RJSL"] as decimal?;
                obj.JMY = reader["JMY"] as string;
                obj.WGFB = reader["WGFB"] as string;
                obj.YYB = reader["YYB"] as string;
                obj.PEI = reader["PEI"] as string;
                obj.LSLS = reader["LSLS"] as decimal?;
                obj.RSLS = reader["RSLS"] as decimal?;
                obj.LJSLS = reader["LJSLS"] as decimal?;
                obj.RJSLS = reader["RJSLS"] as decimal?;
                obj.RTL = reader["RTL"] as string;
                obj.WSZQ = reader["WSZQ"] as string;
                obj.RS = reader["RS"] as string;
                obj.BXP = reader["BXP"] as decimal?;
                obj.XXB = reader["XXB"] as decimal?;
                obj.SFZH = reader["SFZH"] as string;
                obj.DH = reader["DH"] as string;
                obj.ADDRESS2 = reader["ADDRESS2"] as string;
                obj.RXYFJZS = reader["RXYFJZS"] as string;
                obj.YMA = reader["YMA"] as string;
                obj.YMAJY = reader["YMAJY"] as string;
                obj.YMB = reader["YMB"] as string;
                obj.YMBJY = reader["YMBJY"] as string;
                obj.YMC = reader["YMC"] as string;
                obj.YMCJY = reader["YMCJY"] as string;
                obj.YMD = reader["YMD"] as string;
                obj.YMDJY = reader["YMDJY"] as string;
                obj.YME = reader["YME"] as string;
                obj.YMEJY = reader["YMEJY"] as string;
                obj.YMQT = reader["YMQT"] as string;
                obj.RXHJZS = reader["RXHJZS"] as string;
                obj.JWBS = reader["JWBS"] as string;
                obj.QCQFY = reader["QCQFY"] as int?;
                obj.STUDGUID = reader["STUDGUID"] as string;
                obj.SCHOOLID = reader["SCHOOLID"] as string;
                obj.STUDNUM = reader["STUDNUM"] as string;
                obj.YMF = reader["YMF"] as string;
                obj.YMFJY = reader["YMFJY"] as string;
                list.Add(obj);
            }
            return list;
         }
        public HW_Result2013 Mapper(SqlDataReader reader)
         {
            HW_Result2013 obj=null;
            if (reader.Read())
            {
                obj = new HW_Result2013();
                obj.TJND = (string)reader["TJND6"];
                obj.BH = (string)reader["BH"];
                obj.CHECKID = (decimal)reader["CHECKID"];
                obj.SCHOOLBH = (string)reader["SCHOOLBH"];
                obj.GRADEBH = (string)reader["GRADEBH4"];
                obj.CLASSBH = (string)reader["CLASSBH2"];
                obj.RXSJ = reader["RXSJ"] as string;
                obj.XH = reader["XH"] as string;
                obj.SCHOOL_NAME = reader["SCHOOL_NAME"] as string;
                obj.GRADE_NAME = reader["GRADE_NAME"] as string;
                obj.CLASS_NAME = reader["CLASS_NAME"] as string;
                obj.XM = reader["XM"] as string;
                obj.XB = (string)reader["XB"];
                obj.CSRQ = (DateTime)reader["CSRQ"];
                obj.MZ = reader["MZ"] as string;
                obj.ZZMM = reader["ZZMM"] as string;
                obj.SY = reader["SY"] as string;
                    obj.TJRQ = reader["TJRQ"] as DateTime?;
                    obj.NL = reader["NL"] as int?;
                obj.MARK = reader["MARK"] as string;
                    obj.SG = reader["SG"] as decimal?;
                obj.SGDJQ = reader["SGDJQ"] as string;
                obj.SGDJD = reader["SGDJD"] as string;
                obj.SGBJ = reader["SGBJ"] as string;
                    obj.TZ = reader["TZ"] as decimal?;
                obj.TZDJQ = reader["TZDJQ"] as string;
                obj.TZDJD = reader["TZDJD"] as string;
                obj.TZBJ = reader["TZBJ"] as string;
                obj.YYPJ = reader["YYPJ"] as string;
                obj.YYPJX = reader["YYPJX"] as string;
                obj.TXPJ = reader["TXPJ"] as string;
                obj.FYPJ = reader["FYPJ"] as string;
                    obj.XW = reader["XW"] as decimal?;
                obj.XWDJQ = reader["XWDJQ"] as string;
                obj.XWDJD = reader["XWDJD"] as string;
                obj.XWBJ = reader["XWBJ"] as string;
                    obj.FHL = reader["FHL"] as decimal?;
                obj.FHLDJQ = reader["FHLDJQ"] as string;
                obj.FHLDJD = reader["FHLDJD"] as string;
                obj.FHLBJ = reader["FHLBJ"] as string;
                    obj.WL = reader["WL"] as decimal?;
                obj.WLDJQ = reader["WLDJQ"] as string;
                obj.WLDJD = reader["WLDJD"] as string;
                obj.WLBJ = reader["WLBJ"] as string;
                    obj.MB = reader["MB"] as decimal?;
                obj.MBBJ = reader["MBBJ"] as string;
                    obj.SSY = reader["SSY"] as decimal?;
                obj.SSYBJ = reader["SSYBJ"] as string;
                    obj.SZY = reader["SZY"] as decimal?;
                obj.SZYBJ = reader["SZYBJ"] as string;
                    obj.LSL = reader["LSL"] as decimal?;
                    obj.RSL = reader["RSL"] as decimal?;
                obj.QTYB = reader["QTYB"] as string;
                obj.LQG = reader["LQG"] as string;
                obj.RQG = reader["RQG"] as string;
                obj.LSY = reader["LSY"] as string;
                obj.RSY = reader["RSY"] as string;
                obj.BS = reader["BS"] as string;
                obj.TL = reader["TL"] as string;
                obj.XJ = reader["XJ"] as string;
                obj.BB = reader["BB"] as string;
                    obj.QSBNUM = reader["QSBNUM"] as int?;
                    obj.RQB = reader["RQB"] as int?;
                    obj.RQS = reader["RQS"] as int?;
                    obj.RQH = reader["RQH"] as int?;
                    obj.HQB = reader["HQB"] as int?;
                    obj.HQS = reader["HQS"] as int?;
                    obj.HQH = reader["HQH"] as int?;
                obj.YZB = reader["YZB"] as string;
                obj.BTT = reader["BTT"] as string;
                obj.XK = reader["XK"] as string;
                obj.JZ = reader["JZ"] as string;
                obj.SZ = reader["SZ"] as string;
                obj.PZ = reader["PZ"] as string;
                obj.XZ = reader["XZ"] as string;
                obj.GP = reader["GP"] as string;
                obj.FEI = reader["FEI"] as string;
                obj.XT = reader["XT"] as string;
                    obj.XHDB = reader["XHDB"] as int?;
                obj.FHCL = reader["FHCL"] as string;
                obj.PFB = reader["PFB"] as string;
                    obj.ZG = reader["ZG"] as decimal?;
                obj.ZGDJQ = reader["ZGDJQ"] as string;
                obj.ZGDJD = reader["ZGDJD"] as string;
                obj.ZGBJ = reader["ZGBJ"] as string;
                    obj.JK = reader["JK"] as decimal?;
                obj.JKDJQ = reader["JKDJQ"] as string;
                obj.JKDJD = reader["JKDJD"] as string;
                obj.JKBJ = reader["JKBJ"] as string;
                    obj.GPK = reader["GPK"] as decimal?;
                obj.GPKDJQ = reader["GPKDJQ"] as string;
                obj.GPKDJD = reader["GPKDJD"] as string;
                obj.GPKBJ = reader["GPKBJ"] as string;
                    obj.BJL = reader["BJL"] as decimal?;
                    obj.GSTJ = reader["GSTJ"] as decimal?;
                    obj.JJX = reader["JJX"] as decimal?;
                obj.BMKY = reader["BMKY"] as string;
                obj.SJSR = reader["SJSR"] as string;
                    obj.WSM = reader["WSM"] as decimal?;
                obj.WSMDJQ = reader["WSMDJQ"] as string;
                obj.WSMDJD = reader["WSMDJD"] as string;
                obj.WSMBJ = reader["WSMBJ"] as string;
                    obj.LDTY = reader["LDTY"] as decimal?;
                obj.LDTYDJQ = reader["LDTYDJQ"] as string;
                obj.LDTYDJD = reader["LDTYDJD"] as string;
                obj.LDTYBJ = reader["LDTYBJ"] as string;
                    obj.LL = reader["LL"] as decimal?;
                obj.LLDJQ = reader["LLDJQ"] as string;
                obj.LLDJD = reader["LLDJD"] as string;
                obj.LLBJ = reader["LLBJ"] as string;
                    obj.NNL = reader["NNL"] as decimal?;
                obj.NNLDJQ = reader["NNLDJQ"] as string;
                obj.NNLDJD = reader["NNLDJD"] as string;
                obj.NNLBJ = reader["NNLBJ"] as string;
                    obj.ZWT = reader["ZWT"] as decimal?;
                obj.ZWTDJQ = reader["ZWTDJQ"] as string;
                obj.ZWTDJD = reader["ZWTDJD"] as string;
                obj.ZWTBJ = reader["ZWTBJ"] as string;
                obj.T1 = reader["T1"] as string;
                obj.T2 = reader["T2"] as string;
                obj.T3 = reader["T3"] as string;
                obj.T4 = reader["T4"] as string;
                obj.T5 = reader["T5"] as string;
                obj.T6 = reader["T6"] as string;
                obj.T7 = reader["T7"] as string;
                obj.T8 = reader["T8"] as string;
                obj.T9 = reader["T9"] as string;
                obj.T10 = reader["T10"] as string;
                obj.SLBH = reader["SLBH"] as string;
                obj.MBPJ = reader["MBPJ"] as string;
                obj.SSYPJ = reader["SSYPJ"] as string;
                obj.SZYPJ = reader["SZYPJ"] as string;
                obj.PXPJ = reader["PXPJ"] as string;
                obj.SLPJ = reader["SLPJ"] as string;
                obj.XJH = reader["XJH"] as string;
                obj.YYPJB = reader["YYPJB"] as string;
                    obj.TJSY = reader["TJSY"] as int?;
                    obj.MB1 = reader["MB1"] as int?;
                    obj.MB2 = reader["MB2"] as int?;
                    obj.MB3 = reader["MB3"] as int?;
                    obj.TJFS = reader["TJFS"] as int?;
                obj.TJPJ = reader["TJPJ"] as string;
                obj.YYPJH = reader["YYPJH"] as string;
                obj.XMPY = reader["XMPY"] as string;
                    obj.HXP = reader["HXP"] as decimal?;
                obj.HXPPJ = reader["HXPPJ"] as string;
                obj.EB = reader["EB"] as string;
                obj.YB = reader["YB"] as string;
                obj.TB = reader["TB"] as string;
                obj.JB = reader["JB"] as string;
                obj.PF = reader["PF"] as string;
                obj.JZX = reader["JZX"] as string;
                obj.LBJ = reader["LBJ"] as string;
                obj.JHJS = reader["JHJS"] as string;
                    obj.GBZAM = reader["GBZAM"] as decimal?;
                    obj.DHSA = reader["DHSA"] as decimal?;
                    obj.DHSZ = reader["DHSZ"] as decimal?;
                obj.GG = reader["GG"] as string;
                obj.BMKT = reader["BMKT"] as string;
                obj.YGHKT = reader["YGHKT"] as string;
                obj.YGEKY = reader["YGEKY"] as string;
                obj.YGEKT = reader["YGEKT"] as string;
                obj.BLOOD = reader["BLOOD"] as string;
                    obj.YW = reader["YW"] as decimal?;
                    obj.TW = reader["TW"] as decimal?;
                obj.CXBH = reader["CXBH"] as string;
                    obj.LJSL = reader["LJSL"] as decimal?;
                    obj.RJSL = reader["RJSL"] as decimal?;
                obj.JMY = reader["JMY"] as string;
                obj.WGFB = reader["WGFB"] as string;
                obj.YYB = reader["YYB"] as string;
                obj.PEI = reader["PEI"] as string;
                    obj.LSLS = reader["LSLS"] as decimal?;
                    obj.RSLS = reader["RSLS"] as decimal?;
                    obj.LJSLS = reader["LJSLS"] as decimal?;
                    obj.RJSLS = reader["RJSLS"] as decimal?;
                obj.RTL = reader["RTL"] as string;
                obj.WSZQ = reader["WSZQ"] as string;
                obj.RS = reader["RS"] as string;
                    obj.BXP = reader["BXP"] as decimal?;
                    obj.XXB = reader["XXB"] as decimal?;
                obj.SFZH = reader["SFZH"] as string;
                obj.DH = reader["DH"] as string;
                obj.ADDRESS2 = reader["ADDRESS"] as string;
                obj.RXYFJZS = reader["RXYFJZS"] as string;
                obj.YMA = reader["YMA"] as string;
                obj.YMAJY = reader["YMAJY"] as string;
                obj.YMB = reader["YMB"] as string;
                obj.YMBJY = reader["YMBJY"] as string;
                obj.YMC = reader["YMC"] as string;
                obj.YMCJY = reader["YMCJY"] as string;
                obj.YMD = reader["YMD"] as string;
                obj.YMDJY = reader["YMDJY"] as string;
                obj.YME = reader["YME"] as string;
                obj.YMEJY = reader["YMEJY"] as string;
                obj.YMQT = reader["YMQT"] as string;
                obj.RXHJZS = reader["RXHJZS"] as string;
                obj.JWBS = reader["JWBS"] as string;
                    obj.QCQFY = reader["QCQFY"] as int?;
                obj.STUDGUID = reader["STUDGUID"] as string;
                obj.SCHOOLID = reader["SCHOOLID"] as string;
                obj.STUDNUM = reader["STUDNUM"] as string;
                obj.YMF = reader["YMF"] as string;
                obj.YMFJY = reader["YMFJY"] as string;
            }
            return obj;
         }
        #endregion
        #region##通过主键ID得到HW_Result2013
        /// <summary>
        /// 功能：通过ID得到HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30   
        /// </summary>
        /// <param name="">主键ID</param>
        /// <returns></returns>
        public HW_Result2013 GetById(string tjnd6)
        {            
            string sql = "select * from HW_Result2013 where TJND6 = @PK";
            SqlParameter[] sp = new SqlParameter[]
            {
                new SqlParameter("@PK",5)
            };
            
            SqlDataReader reader=SqlHelper.ExecuteReader(WebConn.connString,CommandType.Text,sql,sp);
            return Mapper(reader);
        }
        #endregion
		
		#region##通过主键ID删除HW_Result2013
        /// <summary>
        /// 功能：通过主键ID删除HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30   
        /// </summary>
        /// <param name="">主键ID</param>
        /// <returns></returns>
		public int DeleteById(string tjnd6)
		{
			int i = 0;
			string sql = "delete from HW_Result2013 where TJND6 = @PK";
            SqlParameter[] sp = new SqlParameter[]
            {
                new SqlParameter("@PK",5)
            };
            i= SqlHelper.ExecuteNonQuery(WebConn.connString,CommandType.Text,sql,sp);
			return i;
		}
        /// <summary>
        /// 功能：通过主键ID删除HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30   
        /// </summary>
        /// <param name="">主键ID</param>
        /// <returns></returns>
		public int DeleteById(SqlTransaction transaction,string tjnd6)
		{
			int i = 0;
			string sql = "delete from HW_Result2013 where TJND6 = @PK";
            SqlParameter[] sp = new SqlParameter[]
            {
                new SqlParameter("@PK",5)
            };
            i= SqlHelper.ExecuteNonQuery(transaction,CommandType.Text,sql,sp);
			return i;
		}
		#endregion			
		
        #region##添加HW_Result2013
        /// <summary>
        /// 功能：添加HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public int Add(HW_Result2013 hw_result2013)
        {
            int result = 0;
            string sql = "insert into HW_Result2013(TJND6,BH,CHECKID,SCHOOLBH,GRADEBH4,CLASSBH2,RXSJ,XH,SCHOOL_NAME,GRADE_NAME,CLASS_NAME,XM,XB,CSRQ,MZ,ZZMM,SY,TJRQ,NL,MARK,SG,SGDJQ,SGDJD,SGBJ,TZ,TZDJQ,TZDJD,TZBJ,YYPJ,YYPJX,TXPJ,FYPJ,XW,XWDJQ,XWDJD,XWBJ,FHL,FHLDJQ,FHLDJD,FHLBJ,WL,WLDJQ,WLDJD,WLBJ,MB,MBBJ,SSY,SSYBJ,SZY,SZYBJ,LSL,RSL,QTYB,LQG,RQG,LSY,RSY,BS,TL,XJ,BB,QSBNUM,RQB,RQS,RQH,HQB,HQS,HQH,YZB,BTT,XK,JZ,SZ,PZ,XZ,GP,FEI,XT,XHDB,FHCL,PFB,ZG,ZGDJQ,ZGDJD,ZGBJ,JK,JKDJQ,JKDJD,JKBJ,GPK,GPKDJQ,GPKDJD,GPKBJ,BJL,GSTJ,JJX,BMKY,SJSR,WSM,WSMDJQ,WSMDJD,WSMBJ,LDTY,LDTYDJQ,LDTYDJD,LDTYBJ,LL,LLDJQ,LLDJD,LLBJ,NNL,NNLDJQ,NNLDJD,NNLBJ,ZWT,ZWTDJQ,ZWTDJD,ZWTBJ,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,SLBH,MBPJ,SSYPJ,SZYPJ,PXPJ,SLPJ,XJH,YYPJB,TJSY,MB1,MB2,MB3,TJFS,TJPJ,YYPJH,XMPY,HXP,HXPPJ,EB,YB,TB,JB,PF,JZX,LBJ,JHJS,GBZAM,DHSA,DHSZ,GG,BMKT,YGHKT,YGEKY,YGEKT,BLOOD,YW,TW,CXBH,LJSL,RJSL,JMY,WGFB,YYB,PEI,LSLS,RSLS,LJSLS,RJSLS,RTL,WSZQ,RS,BXP,XXB,SFZH,DH,ADDRESS2,RXYFJZS,YMA,YMAJY,YMB,YMBJY,YMC,YMCJY,YMD,YMDJY,YME,YMEJY,YMQT,RXHJZS,JWBS,QCQFY,STUDGUID,SCHOOLID,STUDNUM,YMF,YMFJY) values(@TJND6,@BH,@CHECKID,@SCHOOLBH,@GRADEBH4,@CLASSBH2,@RXSJ,@XH,@SCHOOL_NAME,@GRADE_NAME,@CLASS_NAME,@XM,@XB,@CSRQ,@MZ,@ZZMM,@SY,@TJRQ,@NL,@MARK,@SG,@SGDJQ,@SGDJD,@SGBJ,@TZ,@TZDJQ,@TZDJD,@TZBJ,@YYPJ,@YYPJX,@TXPJ,@FYPJ,@XW,@XWDJQ,@XWDJD,@XWBJ,@FHL,@FHLDJQ,@FHLDJD,@FHLBJ,@WL,@WLDJQ,@WLDJD,@WLBJ,@MB,@MBBJ,@SSY,@SSYBJ,@SZY,@SZYBJ,@LSL,@RSL,@QTYB,@LQG,@RQG,@LSY,@RSY,@BS,@TL,@XJ,@BB,@QSBNUM,@RQB,@RQS,@RQH,@HQB,@HQS,@HQH,@YZB,@BTT,@XK,@JZ,@SZ,@PZ,@XZ,@GP,@FEI,@XT,@XHDB,@FHCL,@PFB,@ZG,@ZGDJQ,@ZGDJD,@ZGBJ,@JK,@JKDJQ,@JKDJD,@JKBJ,@GPK,@GPKDJQ,@GPKDJD,@GPKBJ,@BJL,@GSTJ,@JJX,@BMKY,@SJSR,@WSM,@WSMDJQ,@WSMDJD,@WSMBJ,@LDTY,@LDTYDJQ,@LDTYDJD,@LDTYBJ,@LL,@LLDJQ,@LLDJD,@LLBJ,@NNL,@NNLDJQ,@NNLDJD,@NNLBJ,@ZWT,@ZWTDJQ,@ZWTDJD,@ZWTBJ,@T1,@T2,@T3,@T4,@T5,@T6,@T7,@T8,@T9,@T10,@SLBH,@MBPJ,@SSYPJ,@SZYPJ,@PXPJ,@SLPJ,@XJH,@YYPJB,@TJSY,@MB1,@MB2,@MB3,@TJFS,@TJPJ,@YYPJH,@XMPY,@HXP,@HXPPJ,@EB,@YB,@TB,@JB,@PF,@JZX,@LBJ,@JHJS,@GBZAM,@DHSA,@DHSZ,@GG,@BMKT,@YGHKT,@YGEKY,@YGEKT,@BLOOD,@YW,@TW,@CXBH,@LJSL,@RJSL,@JMY,@WGFB,@YYB,@PEI,@LSLS,@RSLS,@LJSLS,@RJSLS,@RTL,@WSZQ,@RS,@BXP,@XXB,@SFZH,@DH,@ADDRESS2,@RXYFJZS,@YMA,@YMAJY,@YMB,@YMBJY,@YMC,@YMCJY,@YMD,@YMDJY,@YME,@YMEJY,@YMQT,@RXHJZS,@JWBS,@QCQFY,@STUDGUID,@SCHOOLID,@STUDNUM,@YMF,@YMFJY)";			
            SqlParameter[] sp = new SqlParameter[]
            {
				new SqlParameter("@TJND6",hw_result2013.TJND),
				new SqlParameter("@BH",hw_result2013.BH),
				new SqlParameter("@CHECKID",hw_result2013.CHECKID),
				new SqlParameter("@SCHOOLBH",hw_result2013.SCHOOLBH),
				new SqlParameter("@GRADEBH4",hw_result2013.GRADEBH),
				new SqlParameter("@CLASSBH2",hw_result2013.CLASSBH),
				new SqlParameter("@RXSJ",hw_result2013.RXSJ),
				new SqlParameter("@XH",hw_result2013.XH),
				new SqlParameter("@SCHOOL_NAME",hw_result2013.SCHOOL_NAME),
				new SqlParameter("@GRADE_NAME",hw_result2013.GRADE_NAME),
				new SqlParameter("@CLASS_NAME",hw_result2013.CLASS_NAME),
				new SqlParameter("@XM",hw_result2013.XM),
				new SqlParameter("@XB",hw_result2013.XB),
				new SqlParameter("@CSRQ",hw_result2013.CSRQ),
				new SqlParameter("@MZ",hw_result2013.MZ),
				new SqlParameter("@ZZMM",hw_result2013.ZZMM),
				new SqlParameter("@SY",hw_result2013.SY),
				new SqlParameter("@TJRQ",hw_result2013.TJRQ),
				new SqlParameter("@NL",hw_result2013.NL),
				new SqlParameter("@MARK",hw_result2013.MARK),
				new SqlParameter("@SG",hw_result2013.SG),
				new SqlParameter("@SGDJQ",hw_result2013.SGDJQ),
				new SqlParameter("@SGDJD",hw_result2013.SGDJD),
				new SqlParameter("@SGBJ",hw_result2013.SGBJ),
				new SqlParameter("@TZ",hw_result2013.TZ),
				new SqlParameter("@TZDJQ",hw_result2013.TZDJQ),
				new SqlParameter("@TZDJD",hw_result2013.TZDJD),
				new SqlParameter("@TZBJ",hw_result2013.TZBJ),
				new SqlParameter("@YYPJ",hw_result2013.YYPJ),
				new SqlParameter("@YYPJX",hw_result2013.YYPJX),
				new SqlParameter("@TXPJ",hw_result2013.TXPJ),
				new SqlParameter("@FYPJ",hw_result2013.FYPJ),
				new SqlParameter("@XW",hw_result2013.XW),
				new SqlParameter("@XWDJQ",hw_result2013.XWDJQ),
				new SqlParameter("@XWDJD",hw_result2013.XWDJD),
				new SqlParameter("@XWBJ",hw_result2013.XWBJ),
				new SqlParameter("@FHL",hw_result2013.FHL),
				new SqlParameter("@FHLDJQ",hw_result2013.FHLDJQ),
				new SqlParameter("@FHLDJD",hw_result2013.FHLDJD),
				new SqlParameter("@FHLBJ",hw_result2013.FHLBJ),
				new SqlParameter("@WL",hw_result2013.WL),
				new SqlParameter("@WLDJQ",hw_result2013.WLDJQ),
				new SqlParameter("@WLDJD",hw_result2013.WLDJD),
				new SqlParameter("@WLBJ",hw_result2013.WLBJ),
				new SqlParameter("@MB",hw_result2013.MB),
				new SqlParameter("@MBBJ",hw_result2013.MBBJ),
				new SqlParameter("@SSY",hw_result2013.SSY),
				new SqlParameter("@SSYBJ",hw_result2013.SSYBJ),
				new SqlParameter("@SZY",hw_result2013.SZY),
				new SqlParameter("@SZYBJ",hw_result2013.SZYBJ),
				new SqlParameter("@LSL",hw_result2013.LSL),
				new SqlParameter("@RSL",hw_result2013.RSL),
				new SqlParameter("@QTYB",hw_result2013.QTYB),
				new SqlParameter("@LQG",hw_result2013.LQG),
				new SqlParameter("@RQG",hw_result2013.RQG),
				new SqlParameter("@LSY",hw_result2013.LSY),
				new SqlParameter("@RSY",hw_result2013.RSY),
				new SqlParameter("@BS",hw_result2013.BS),
				new SqlParameter("@TL",hw_result2013.TL),
				new SqlParameter("@XJ",hw_result2013.XJ),
				new SqlParameter("@BB",hw_result2013.BB),
				new SqlParameter("@QSBNUM",hw_result2013.QSBNUM),
				new SqlParameter("@RQB",hw_result2013.RQB),
				new SqlParameter("@RQS",hw_result2013.RQS),
				new SqlParameter("@RQH",hw_result2013.RQH),
				new SqlParameter("@HQB",hw_result2013.HQB),
				new SqlParameter("@HQS",hw_result2013.HQS),
				new SqlParameter("@HQH",hw_result2013.HQH),
				new SqlParameter("@YZB",hw_result2013.YZB),
				new SqlParameter("@BTT",hw_result2013.BTT),
				new SqlParameter("@XK",hw_result2013.XK),
				new SqlParameter("@JZ",hw_result2013.JZ),
				new SqlParameter("@SZ",hw_result2013.SZ),
				new SqlParameter("@PZ",hw_result2013.PZ),
				new SqlParameter("@XZ",hw_result2013.XZ),
				new SqlParameter("@GP",hw_result2013.GP),
				new SqlParameter("@FEI",hw_result2013.FEI),
				new SqlParameter("@XT",hw_result2013.XT),
				new SqlParameter("@XHDB",hw_result2013.XHDB),
				new SqlParameter("@FHCL",hw_result2013.FHCL),
				new SqlParameter("@PFB",hw_result2013.PFB),
				new SqlParameter("@ZG",hw_result2013.ZG),
				new SqlParameter("@ZGDJQ",hw_result2013.ZGDJQ),
				new SqlParameter("@ZGDJD",hw_result2013.ZGDJD),
				new SqlParameter("@ZGBJ",hw_result2013.ZGBJ),
				new SqlParameter("@JK",hw_result2013.JK),
				new SqlParameter("@JKDJQ",hw_result2013.JKDJQ),
				new SqlParameter("@JKDJD",hw_result2013.JKDJD),
				new SqlParameter("@JKBJ",hw_result2013.JKBJ),
				new SqlParameter("@GPK",hw_result2013.GPK),
				new SqlParameter("@GPKDJQ",hw_result2013.GPKDJQ),
				new SqlParameter("@GPKDJD",hw_result2013.GPKDJD),
				new SqlParameter("@GPKBJ",hw_result2013.GPKBJ),
				new SqlParameter("@BJL",hw_result2013.BJL),
				new SqlParameter("@GSTJ",hw_result2013.GSTJ),
				new SqlParameter("@JJX",hw_result2013.JJX),
				new SqlParameter("@BMKY",hw_result2013.BMKY),
				new SqlParameter("@SJSR",hw_result2013.SJSR),
				new SqlParameter("@WSM",hw_result2013.WSM),
				new SqlParameter("@WSMDJQ",hw_result2013.WSMDJQ),
				new SqlParameter("@WSMDJD",hw_result2013.WSMDJD),
				new SqlParameter("@WSMBJ",hw_result2013.WSMBJ),
				new SqlParameter("@LDTY",hw_result2013.LDTY),
				new SqlParameter("@LDTYDJQ",hw_result2013.LDTYDJQ),
				new SqlParameter("@LDTYDJD",hw_result2013.LDTYDJD),
				new SqlParameter("@LDTYBJ",hw_result2013.LDTYBJ),
				new SqlParameter("@LL",hw_result2013.LL),
				new SqlParameter("@LLDJQ",hw_result2013.LLDJQ),
				new SqlParameter("@LLDJD",hw_result2013.LLDJD),
				new SqlParameter("@LLBJ",hw_result2013.LLBJ),
				new SqlParameter("@NNL",hw_result2013.NNL),
				new SqlParameter("@NNLDJQ",hw_result2013.NNLDJQ),
				new SqlParameter("@NNLDJD",hw_result2013.NNLDJD),
				new SqlParameter("@NNLBJ",hw_result2013.NNLBJ),
				new SqlParameter("@ZWT",hw_result2013.ZWT),
				new SqlParameter("@ZWTDJQ",hw_result2013.ZWTDJQ),
				new SqlParameter("@ZWTDJD",hw_result2013.ZWTDJD),
				new SqlParameter("@ZWTBJ",hw_result2013.ZWTBJ),
				new SqlParameter("@T1",hw_result2013.T1),
				new SqlParameter("@T2",hw_result2013.T2),
				new SqlParameter("@T3",hw_result2013.T3),
				new SqlParameter("@T4",hw_result2013.T4),
				new SqlParameter("@T5",hw_result2013.T5),
				new SqlParameter("@T6",hw_result2013.T6),
				new SqlParameter("@T7",hw_result2013.T7),
				new SqlParameter("@T8",hw_result2013.T8),
				new SqlParameter("@T9",hw_result2013.T9),
				new SqlParameter("@T10",hw_result2013.T10),
				new SqlParameter("@SLBH",hw_result2013.SLBH),
				new SqlParameter("@MBPJ",hw_result2013.MBPJ),
				new SqlParameter("@SSYPJ",hw_result2013.SSYPJ),
				new SqlParameter("@SZYPJ",hw_result2013.SZYPJ),
				new SqlParameter("@PXPJ",hw_result2013.PXPJ),
				new SqlParameter("@SLPJ",hw_result2013.SLPJ),
				new SqlParameter("@XJH",hw_result2013.XJH),
				new SqlParameter("@YYPJB",hw_result2013.YYPJB),
				new SqlParameter("@TJSY",hw_result2013.TJSY),
				new SqlParameter("@MB1",hw_result2013.MB1),
				new SqlParameter("@MB2",hw_result2013.MB2),
				new SqlParameter("@MB3",hw_result2013.MB3),
				new SqlParameter("@TJFS",hw_result2013.TJFS),
				new SqlParameter("@TJPJ",hw_result2013.TJPJ),
				new SqlParameter("@YYPJH",hw_result2013.YYPJH),
				new SqlParameter("@XMPY",hw_result2013.XMPY),
				new SqlParameter("@HXP",hw_result2013.HXP),
				new SqlParameter("@HXPPJ",hw_result2013.HXPPJ),
				new SqlParameter("@EB",hw_result2013.EB),
				new SqlParameter("@YB",hw_result2013.YB),
				new SqlParameter("@TB",hw_result2013.TB),
				new SqlParameter("@JB",hw_result2013.JB),
				new SqlParameter("@PF",hw_result2013.PF),
				new SqlParameter("@JZX",hw_result2013.JZX),
				new SqlParameter("@LBJ",hw_result2013.LBJ),
				new SqlParameter("@JHJS",hw_result2013.JHJS),
				new SqlParameter("@GBZAM",hw_result2013.GBZAM),
				new SqlParameter("@DHSA",hw_result2013.DHSA),
				new SqlParameter("@DHSZ",hw_result2013.DHSZ),
				new SqlParameter("@GG",hw_result2013.GG),
				new SqlParameter("@BMKT",hw_result2013.BMKT),
				new SqlParameter("@YGHKT",hw_result2013.YGHKT),
				new SqlParameter("@YGEKY",hw_result2013.YGEKY),
				new SqlParameter("@YGEKT",hw_result2013.YGEKT),
				new SqlParameter("@BLOOD",hw_result2013.BLOOD),
				new SqlParameter("@YW",hw_result2013.YW),
				new SqlParameter("@TW",hw_result2013.TW),
				new SqlParameter("@CXBH",hw_result2013.CXBH),
				new SqlParameter("@LJSL",hw_result2013.LJSL),
				new SqlParameter("@RJSL",hw_result2013.RJSL),
				new SqlParameter("@JMY",hw_result2013.JMY),
				new SqlParameter("@WGFB",hw_result2013.WGFB),
				new SqlParameter("@YYB",hw_result2013.YYB),
				new SqlParameter("@PEI",hw_result2013.PEI),
				new SqlParameter("@LSLS",hw_result2013.LSLS),
				new SqlParameter("@RSLS",hw_result2013.RSLS),
				new SqlParameter("@LJSLS",hw_result2013.LJSLS),
				new SqlParameter("@RJSLS",hw_result2013.RJSLS),
				new SqlParameter("@RTL",hw_result2013.RTL),
				new SqlParameter("@WSZQ",hw_result2013.WSZQ),
				new SqlParameter("@RS",hw_result2013.RS),
				new SqlParameter("@BXP",hw_result2013.BXP),
				new SqlParameter("@XXB",hw_result2013.XXB),
				new SqlParameter("@SFZH",hw_result2013.SFZH),
				new SqlParameter("@DH",hw_result2013.DH),
				new SqlParameter("@ADDRESS2",hw_result2013.ADDRESS2),
				new SqlParameter("@RXYFJZS",hw_result2013.RXYFJZS),
				new SqlParameter("@YMA",hw_result2013.YMA),
				new SqlParameter("@YMAJY",hw_result2013.YMAJY),
				new SqlParameter("@YMB",hw_result2013.YMB),
				new SqlParameter("@YMBJY",hw_result2013.YMBJY),
				new SqlParameter("@YMC",hw_result2013.YMC),
				new SqlParameter("@YMCJY",hw_result2013.YMCJY),
				new SqlParameter("@YMD",hw_result2013.YMD),
				new SqlParameter("@YMDJY",hw_result2013.YMDJY),
				new SqlParameter("@YME",hw_result2013.YME),
				new SqlParameter("@YMEJY",hw_result2013.YMEJY),
				new SqlParameter("@YMQT",hw_result2013.YMQT),
				new SqlParameter("@RXHJZS",hw_result2013.RXHJZS),
				new SqlParameter("@JWBS",hw_result2013.JWBS),
				new SqlParameter("@QCQFY",hw_result2013.QCQFY),
				new SqlParameter("@STUDGUID",hw_result2013.STUDGUID),
				new SqlParameter("@SCHOOLID",hw_result2013.SCHOOLID),
				new SqlParameter("@STUDNUM",hw_result2013.STUDNUM),
				new SqlParameter("@YMF",hw_result2013.YMF),
				new SqlParameter("@YMFJY",hw_result2013.YMFJY)
            };
            result = SqlHelper.ExecuteNonQuery(WebConn.connString,CommandType.Text,sql,sp);
            return result;
        }
         /// <summary>
        /// 功能：添加HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public int Add(SqlTransaction transaction,HW_Result2013 hw_result2013)
        {
            int result = 0;
            string sql = "insert into HW_Result2013(TJND6,BH,CHECKID,SCHOOLBH,GRADEBH4,CLASSBH2,RXSJ,XH,SCHOOL_NAME,GRADE_NAME,CLASS_NAME,XM,XB,CSRQ,MZ,ZZMM,SY,TJRQ,NL,MARK,SG,SGDJQ,SGDJD,SGBJ,TZ,TZDJQ,TZDJD,TZBJ,YYPJ,YYPJX,TXPJ,FYPJ,XW,XWDJQ,XWDJD,XWBJ,FHL,FHLDJQ,FHLDJD,FHLBJ,WL,WLDJQ,WLDJD,WLBJ,MB,MBBJ,SSY,SSYBJ,SZY,SZYBJ,LSL,RSL,QTYB,LQG,RQG,LSY,RSY,BS,TL,XJ,BB,QSBNUM,RQB,RQS,RQH,HQB,HQS,HQH,YZB,BTT,XK,JZ,SZ,PZ,XZ,GP,FEI,XT,XHDB,FHCL,PFB,ZG,ZGDJQ,ZGDJD,ZGBJ,JK,JKDJQ,JKDJD,JKBJ,GPK,GPKDJQ,GPKDJD,GPKBJ,BJL,GSTJ,JJX,BMKY,SJSR,WSM,WSMDJQ,WSMDJD,WSMBJ,LDTY,LDTYDJQ,LDTYDJD,LDTYBJ,LL,LLDJQ,LLDJD,LLBJ,NNL,NNLDJQ,NNLDJD,NNLBJ,ZWT,ZWTDJQ,ZWTDJD,ZWTBJ,T1,T2,T3,T4,T5,T6,T7,T8,T9,T10,SLBH,MBPJ,SSYPJ,SZYPJ,PXPJ,SLPJ,XJH,YYPJB,TJSY,MB1,MB2,MB3,TJFS,TJPJ,YYPJH,XMPY,HXP,HXPPJ,EB,YB,TB,JB,PF,JZX,LBJ,JHJS,GBZAM,DHSA,DHSZ,GG,BMKT,YGHKT,YGEKY,YGEKT,BLOOD,YW,TW,CXBH,LJSL,RJSL,JMY,WGFB,YYB,PEI,LSLS,RSLS,LJSLS,RJSLS,RTL,WSZQ,RS,BXP,XXB,SFZH,DH,ADDRESS2,RXYFJZS,YMA,YMAJY,YMB,YMBJY,YMC,YMCJY,YMD,YMDJY,YME,YMEJY,YMQT,RXHJZS,JWBS,QCQFY,STUDGUID,SCHOOLID,STUDNUM,YMF,YMFJY) values(@TJND6,@BH,@CHECKID,@SCHOOLBH,@GRADEBH4,@CLASSBH2,@RXSJ,@XH,@SCHOOL_NAME,@GRADE_NAME,@CLASS_NAME,@XM,@XB,@CSRQ,@MZ,@ZZMM,@SY,@TJRQ,@NL,@MARK,@SG,@SGDJQ,@SGDJD,@SGBJ,@TZ,@TZDJQ,@TZDJD,@TZBJ,@YYPJ,@YYPJX,@TXPJ,@FYPJ,@XW,@XWDJQ,@XWDJD,@XWBJ,@FHL,@FHLDJQ,@FHLDJD,@FHLBJ,@WL,@WLDJQ,@WLDJD,@WLBJ,@MB,@MBBJ,@SSY,@SSYBJ,@SZY,@SZYBJ,@LSL,@RSL,@QTYB,@LQG,@RQG,@LSY,@RSY,@BS,@TL,@XJ,@BB,@QSBNUM,@RQB,@RQS,@RQH,@HQB,@HQS,@HQH,@YZB,@BTT,@XK,@JZ,@SZ,@PZ,@XZ,@GP,@FEI,@XT,@XHDB,@FHCL,@PFB,@ZG,@ZGDJQ,@ZGDJD,@ZGBJ,@JK,@JKDJQ,@JKDJD,@JKBJ,@GPK,@GPKDJQ,@GPKDJD,@GPKBJ,@BJL,@GSTJ,@JJX,@BMKY,@SJSR,@WSM,@WSMDJQ,@WSMDJD,@WSMBJ,@LDTY,@LDTYDJQ,@LDTYDJD,@LDTYBJ,@LL,@LLDJQ,@LLDJD,@LLBJ,@NNL,@NNLDJQ,@NNLDJD,@NNLBJ,@ZWT,@ZWTDJQ,@ZWTDJD,@ZWTBJ,@T1,@T2,@T3,@T4,@T5,@T6,@T7,@T8,@T9,@T10,@SLBH,@MBPJ,@SSYPJ,@SZYPJ,@PXPJ,@SLPJ,@XJH,@YYPJB,@TJSY,@MB1,@MB2,@MB3,@TJFS,@TJPJ,@YYPJH,@XMPY,@HXP,@HXPPJ,@EB,@YB,@TB,@JB,@PF,@JZX,@LBJ,@JHJS,@GBZAM,@DHSA,@DHSZ,@GG,@BMKT,@YGHKT,@YGEKY,@YGEKT,@BLOOD,@YW,@TW,@CXBH,@LJSL,@RJSL,@JMY,@WGFB,@YYB,@PEI,@LSLS,@RSLS,@LJSLS,@RJSLS,@RTL,@WSZQ,@RS,@BXP,@XXB,@SFZH,@DH,@ADDRESS2,@RXYFJZS,@YMA,@YMAJY,@YMB,@YMBJY,@YMC,@YMCJY,@YMD,@YMDJY,@YME,@YMEJY,@YMQT,@RXHJZS,@JWBS,@QCQFY,@STUDGUID,@SCHOOLID,@STUDNUM,@YMF,@YMFJY)";			
            SqlParameter[] sp = new SqlParameter[]
            {
				new SqlParameter("@TJND6",hw_result2013.TJND),
				new SqlParameter("@BH",hw_result2013.BH),
				new SqlParameter("@CHECKID",hw_result2013.CHECKID),
				new SqlParameter("@SCHOOLBH",hw_result2013.SCHOOLBH),
				new SqlParameter("@GRADEBH4",hw_result2013.GRADEBH),
				new SqlParameter("@CLASSBH2",hw_result2013.CLASSBH),
				new SqlParameter("@RXSJ",hw_result2013.RXSJ),
				new SqlParameter("@XH",hw_result2013.XH),
				new SqlParameter("@SCHOOL_NAME",hw_result2013.SCHOOL_NAME),
				new SqlParameter("@GRADE_NAME",hw_result2013.GRADE_NAME),
				new SqlParameter("@CLASS_NAME",hw_result2013.CLASS_NAME),
				new SqlParameter("@XM",hw_result2013.XM),
				new SqlParameter("@XB",hw_result2013.XB),
				new SqlParameter("@CSRQ",hw_result2013.CSRQ),
				new SqlParameter("@MZ",hw_result2013.MZ),
				new SqlParameter("@ZZMM",hw_result2013.ZZMM),
				new SqlParameter("@SY",hw_result2013.SY),
				new SqlParameter("@TJRQ",hw_result2013.TJRQ),
				new SqlParameter("@NL",hw_result2013.NL),
				new SqlParameter("@MARK",hw_result2013.MARK),
				new SqlParameter("@SG",hw_result2013.SG),
				new SqlParameter("@SGDJQ",hw_result2013.SGDJQ),
				new SqlParameter("@SGDJD",hw_result2013.SGDJD),
				new SqlParameter("@SGBJ",hw_result2013.SGBJ),
				new SqlParameter("@TZ",hw_result2013.TZ),
				new SqlParameter("@TZDJQ",hw_result2013.TZDJQ),
				new SqlParameter("@TZDJD",hw_result2013.TZDJD),
				new SqlParameter("@TZBJ",hw_result2013.TZBJ),
				new SqlParameter("@YYPJ",hw_result2013.YYPJ),
				new SqlParameter("@YYPJX",hw_result2013.YYPJX),
				new SqlParameter("@TXPJ",hw_result2013.TXPJ),
				new SqlParameter("@FYPJ",hw_result2013.FYPJ),
				new SqlParameter("@XW",hw_result2013.XW),
				new SqlParameter("@XWDJQ",hw_result2013.XWDJQ),
				new SqlParameter("@XWDJD",hw_result2013.XWDJD),
				new SqlParameter("@XWBJ",hw_result2013.XWBJ),
				new SqlParameter("@FHL",hw_result2013.FHL),
				new SqlParameter("@FHLDJQ",hw_result2013.FHLDJQ),
				new SqlParameter("@FHLDJD",hw_result2013.FHLDJD),
				new SqlParameter("@FHLBJ",hw_result2013.FHLBJ),
				new SqlParameter("@WL",hw_result2013.WL),
				new SqlParameter("@WLDJQ",hw_result2013.WLDJQ),
				new SqlParameter("@WLDJD",hw_result2013.WLDJD),
				new SqlParameter("@WLBJ",hw_result2013.WLBJ),
				new SqlParameter("@MB",hw_result2013.MB),
				new SqlParameter("@MBBJ",hw_result2013.MBBJ),
				new SqlParameter("@SSY",hw_result2013.SSY),
				new SqlParameter("@SSYBJ",hw_result2013.SSYBJ),
				new SqlParameter("@SZY",hw_result2013.SZY),
				new SqlParameter("@SZYBJ",hw_result2013.SZYBJ),
				new SqlParameter("@LSL",hw_result2013.LSL),
				new SqlParameter("@RSL",hw_result2013.RSL),
				new SqlParameter("@QTYB",hw_result2013.QTYB),
				new SqlParameter("@LQG",hw_result2013.LQG),
				new SqlParameter("@RQG",hw_result2013.RQG),
				new SqlParameter("@LSY",hw_result2013.LSY),
				new SqlParameter("@RSY",hw_result2013.RSY),
				new SqlParameter("@BS",hw_result2013.BS),
				new SqlParameter("@TL",hw_result2013.TL),
				new SqlParameter("@XJ",hw_result2013.XJ),
				new SqlParameter("@BB",hw_result2013.BB),
				new SqlParameter("@QSBNUM",hw_result2013.QSBNUM),
				new SqlParameter("@RQB",hw_result2013.RQB),
				new SqlParameter("@RQS",hw_result2013.RQS),
				new SqlParameter("@RQH",hw_result2013.RQH),
				new SqlParameter("@HQB",hw_result2013.HQB),
				new SqlParameter("@HQS",hw_result2013.HQS),
				new SqlParameter("@HQH",hw_result2013.HQH),
				new SqlParameter("@YZB",hw_result2013.YZB),
				new SqlParameter("@BTT",hw_result2013.BTT),
				new SqlParameter("@XK",hw_result2013.XK),
				new SqlParameter("@JZ",hw_result2013.JZ),
				new SqlParameter("@SZ",hw_result2013.SZ),
				new SqlParameter("@PZ",hw_result2013.PZ),
				new SqlParameter("@XZ",hw_result2013.XZ),
				new SqlParameter("@GP",hw_result2013.GP),
				new SqlParameter("@FEI",hw_result2013.FEI),
				new SqlParameter("@XT",hw_result2013.XT),
				new SqlParameter("@XHDB",hw_result2013.XHDB),
				new SqlParameter("@FHCL",hw_result2013.FHCL),
				new SqlParameter("@PFB",hw_result2013.PFB),
				new SqlParameter("@ZG",hw_result2013.ZG),
				new SqlParameter("@ZGDJQ",hw_result2013.ZGDJQ),
				new SqlParameter("@ZGDJD",hw_result2013.ZGDJD),
				new SqlParameter("@ZGBJ",hw_result2013.ZGBJ),
				new SqlParameter("@JK",hw_result2013.JK),
				new SqlParameter("@JKDJQ",hw_result2013.JKDJQ),
				new SqlParameter("@JKDJD",hw_result2013.JKDJD),
				new SqlParameter("@JKBJ",hw_result2013.JKBJ),
				new SqlParameter("@GPK",hw_result2013.GPK),
				new SqlParameter("@GPKDJQ",hw_result2013.GPKDJQ),
				new SqlParameter("@GPKDJD",hw_result2013.GPKDJD),
				new SqlParameter("@GPKBJ",hw_result2013.GPKBJ),
				new SqlParameter("@BJL",hw_result2013.BJL),
				new SqlParameter("@GSTJ",hw_result2013.GSTJ),
				new SqlParameter("@JJX",hw_result2013.JJX),
				new SqlParameter("@BMKY",hw_result2013.BMKY),
				new SqlParameter("@SJSR",hw_result2013.SJSR),
				new SqlParameter("@WSM",hw_result2013.WSM),
				new SqlParameter("@WSMDJQ",hw_result2013.WSMDJQ),
				new SqlParameter("@WSMDJD",hw_result2013.WSMDJD),
				new SqlParameter("@WSMBJ",hw_result2013.WSMBJ),
				new SqlParameter("@LDTY",hw_result2013.LDTY),
				new SqlParameter("@LDTYDJQ",hw_result2013.LDTYDJQ),
				new SqlParameter("@LDTYDJD",hw_result2013.LDTYDJD),
				new SqlParameter("@LDTYBJ",hw_result2013.LDTYBJ),
				new SqlParameter("@LL",hw_result2013.LL),
				new SqlParameter("@LLDJQ",hw_result2013.LLDJQ),
				new SqlParameter("@LLDJD",hw_result2013.LLDJD),
				new SqlParameter("@LLBJ",hw_result2013.LLBJ),
				new SqlParameter("@NNL",hw_result2013.NNL),
				new SqlParameter("@NNLDJQ",hw_result2013.NNLDJQ),
				new SqlParameter("@NNLDJD",hw_result2013.NNLDJD),
				new SqlParameter("@NNLBJ",hw_result2013.NNLBJ),
				new SqlParameter("@ZWT",hw_result2013.ZWT),
				new SqlParameter("@ZWTDJQ",hw_result2013.ZWTDJQ),
				new SqlParameter("@ZWTDJD",hw_result2013.ZWTDJD),
				new SqlParameter("@ZWTBJ",hw_result2013.ZWTBJ),
				new SqlParameter("@T1",hw_result2013.T1),
				new SqlParameter("@T2",hw_result2013.T2),
				new SqlParameter("@T3",hw_result2013.T3),
				new SqlParameter("@T4",hw_result2013.T4),
				new SqlParameter("@T5",hw_result2013.T5),
				new SqlParameter("@T6",hw_result2013.T6),
				new SqlParameter("@T7",hw_result2013.T7),
				new SqlParameter("@T8",hw_result2013.T8),
				new SqlParameter("@T9",hw_result2013.T9),
				new SqlParameter("@T10",hw_result2013.T10),
				new SqlParameter("@SLBH",hw_result2013.SLBH),
				new SqlParameter("@MBPJ",hw_result2013.MBPJ),
				new SqlParameter("@SSYPJ",hw_result2013.SSYPJ),
				new SqlParameter("@SZYPJ",hw_result2013.SZYPJ),
				new SqlParameter("@PXPJ",hw_result2013.PXPJ),
				new SqlParameter("@SLPJ",hw_result2013.SLPJ),
				new SqlParameter("@XJH",hw_result2013.XJH),
				new SqlParameter("@YYPJB",hw_result2013.YYPJB),
				new SqlParameter("@TJSY",hw_result2013.TJSY),
				new SqlParameter("@MB1",hw_result2013.MB1),
				new SqlParameter("@MB2",hw_result2013.MB2),
				new SqlParameter("@MB3",hw_result2013.MB3),
				new SqlParameter("@TJFS",hw_result2013.TJFS),
				new SqlParameter("@TJPJ",hw_result2013.TJPJ),
				new SqlParameter("@YYPJH",hw_result2013.YYPJH),
				new SqlParameter("@XMPY",hw_result2013.XMPY),
				new SqlParameter("@HXP",hw_result2013.HXP),
				new SqlParameter("@HXPPJ",hw_result2013.HXPPJ),
				new SqlParameter("@EB",hw_result2013.EB),
				new SqlParameter("@YB",hw_result2013.YB),
				new SqlParameter("@TB",hw_result2013.TB),
				new SqlParameter("@JB",hw_result2013.JB),
				new SqlParameter("@PF",hw_result2013.PF),
				new SqlParameter("@JZX",hw_result2013.JZX),
				new SqlParameter("@LBJ",hw_result2013.LBJ),
				new SqlParameter("@JHJS",hw_result2013.JHJS),
				new SqlParameter("@GBZAM",hw_result2013.GBZAM),
				new SqlParameter("@DHSA",hw_result2013.DHSA),
				new SqlParameter("@DHSZ",hw_result2013.DHSZ),
				new SqlParameter("@GG",hw_result2013.GG),
				new SqlParameter("@BMKT",hw_result2013.BMKT),
				new SqlParameter("@YGHKT",hw_result2013.YGHKT),
				new SqlParameter("@YGEKY",hw_result2013.YGEKY),
				new SqlParameter("@YGEKT",hw_result2013.YGEKT),
				new SqlParameter("@BLOOD",hw_result2013.BLOOD),
				new SqlParameter("@YW",hw_result2013.YW),
				new SqlParameter("@TW",hw_result2013.TW),
				new SqlParameter("@CXBH",hw_result2013.CXBH),
				new SqlParameter("@LJSL",hw_result2013.LJSL),
				new SqlParameter("@RJSL",hw_result2013.RJSL),
				new SqlParameter("@JMY",hw_result2013.JMY),
				new SqlParameter("@WGFB",hw_result2013.WGFB),
				new SqlParameter("@YYB",hw_result2013.YYB),
				new SqlParameter("@PEI",hw_result2013.PEI),
				new SqlParameter("@LSLS",hw_result2013.LSLS),
				new SqlParameter("@RSLS",hw_result2013.RSLS),
				new SqlParameter("@LJSLS",hw_result2013.LJSLS),
				new SqlParameter("@RJSLS",hw_result2013.RJSLS),
				new SqlParameter("@RTL",hw_result2013.RTL),
				new SqlParameter("@WSZQ",hw_result2013.WSZQ),
				new SqlParameter("@RS",hw_result2013.RS),
				new SqlParameter("@BXP",hw_result2013.BXP),
				new SqlParameter("@XXB",hw_result2013.XXB),
				new SqlParameter("@SFZH",hw_result2013.SFZH),
				new SqlParameter("@DH",hw_result2013.DH),
				new SqlParameter("@ADDRESS2",hw_result2013.ADDRESS2),
				new SqlParameter("@RXYFJZS",hw_result2013.RXYFJZS),
				new SqlParameter("@YMA",hw_result2013.YMA),
				new SqlParameter("@YMAJY",hw_result2013.YMAJY),
				new SqlParameter("@YMB",hw_result2013.YMB),
				new SqlParameter("@YMBJY",hw_result2013.YMBJY),
				new SqlParameter("@YMC",hw_result2013.YMC),
				new SqlParameter("@YMCJY",hw_result2013.YMCJY),
				new SqlParameter("@YMD",hw_result2013.YMD),
				new SqlParameter("@YMDJY",hw_result2013.YMDJY),
				new SqlParameter("@YME",hw_result2013.YME),
				new SqlParameter("@YMEJY",hw_result2013.YMEJY),
				new SqlParameter("@YMQT",hw_result2013.YMQT),
				new SqlParameter("@RXHJZS",hw_result2013.RXHJZS),
				new SqlParameter("@JWBS",hw_result2013.JWBS),
				new SqlParameter("@QCQFY",hw_result2013.QCQFY),
				new SqlParameter("@STUDGUID",hw_result2013.STUDGUID),
				new SqlParameter("@SCHOOLID",hw_result2013.SCHOOLID),
				new SqlParameter("@STUDNUM",hw_result2013.STUDNUM),
				new SqlParameter("@YMF",hw_result2013.YMF),
				new SqlParameter("@YMFJY",hw_result2013.YMFJY)
            };
            result = SqlHelper.ExecuteNonQuery(transaction,CommandType.Text,sql,sp);
            return result;
        }
        #endregion
		
		#region##得到HW_Result2013集合
		/// <summary>
        /// 功能：得到HW_Result2013集合
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>       
        /// <returns></returns>
		public IList<HW_Result2013> GetList()
		{
			string sql = "select * from HW_Result2013";			
			SqlDataReader reader = SqlHelper.ExecuteReader(WebConn.connString,CommandType.Text,sql);
            return MapperList(reader);
		}
		#endregion
		
		#region##修改HW_Result2013
        /// <summary>
        /// 功能：修改HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public int ModHW_Result2013(HW_Result2013 hw_result2013)
        {
            int result = 0;
            string sql = "update HW_Result2013 set TJND6 = @TJND6,BH = @BH,CHECKID = @CHECKID,SCHOOLBH = @SCHOOLBH,GRADEBH4 = @GRADEBH4,CLASSBH2 = @CLASSBH2,RXSJ = @RXSJ,XH = @XH,SCHOOL_NAME = @SCHOOL_NAME,GRADE_NAME = @GRADE_NAME,CLASS_NAME = @CLASS_NAME,XM = @XM,XB = @XB,CSRQ = @CSRQ,MZ = @MZ,ZZMM = @ZZMM,SY = @SY,TJRQ = @TJRQ,NL = @NL,MARK = @MARK,SG = @SG,SGDJQ = @SGDJQ,SGDJD = @SGDJD,SGBJ = @SGBJ,TZ = @TZ,TZDJQ = @TZDJQ,TZDJD = @TZDJD,TZBJ = @TZBJ,YYPJ = @YYPJ,YYPJX = @YYPJX,TXPJ = @TXPJ,FYPJ = @FYPJ,XW = @XW,XWDJQ = @XWDJQ,XWDJD = @XWDJD,XWBJ = @XWBJ,FHL = @FHL,FHLDJQ = @FHLDJQ,FHLDJD = @FHLDJD,FHLBJ = @FHLBJ,WL = @WL,WLDJQ = @WLDJQ,WLDJD = @WLDJD,WLBJ = @WLBJ,MB = @MB,MBBJ = @MBBJ,SSY = @SSY,SSYBJ = @SSYBJ,SZY = @SZY,SZYBJ = @SZYBJ,LSL = @LSL,RSL = @RSL,QTYB = @QTYB,LQG = @LQG,RQG = @RQG,LSY = @LSY,RSY = @RSY,BS = @BS,TL = @TL,XJ = @XJ,BB = @BB,QSBNUM = @QSBNUM,RQB = @RQB,RQS = @RQS,RQH = @RQH,HQB = @HQB,HQS = @HQS,HQH = @HQH,YZB = @YZB,BTT = @BTT,XK = @XK,JZ = @JZ,SZ = @SZ,PZ = @PZ,XZ = @XZ,GP = @GP,FEI = @FEI,XT = @XT,XHDB = @XHDB,FHCL = @FHCL,PFB = @PFB,ZG = @ZG,ZGDJQ = @ZGDJQ,ZGDJD = @ZGDJD,ZGBJ = @ZGBJ,JK = @JK,JKDJQ = @JKDJQ,JKDJD = @JKDJD,JKBJ = @JKBJ,GPK = @GPK,GPKDJQ = @GPKDJQ,GPKDJD = @GPKDJD,GPKBJ = @GPKBJ,BJL = @BJL,GSTJ = @GSTJ,JJX = @JJX,BMKY = @BMKY,SJSR = @SJSR,WSM = @WSM,WSMDJQ = @WSMDJQ,WSMDJD = @WSMDJD,WSMBJ = @WSMBJ,LDTY = @LDTY,LDTYDJQ = @LDTYDJQ,LDTYDJD = @LDTYDJD,LDTYBJ = @LDTYBJ,LL = @LL,LLDJQ = @LLDJQ,LLDJD = @LLDJD,LLBJ = @LLBJ,NNL = @NNL,NNLDJQ = @NNLDJQ,NNLDJD = @NNLDJD,NNLBJ = @NNLBJ,ZWT = @ZWT,ZWTDJQ = @ZWTDJQ,ZWTDJD = @ZWTDJD,ZWTBJ = @ZWTBJ,T1 = @T1,T2 = @T2,T3 = @T3,T4 = @T4,T5 = @T5,T6 = @T6,T7 = @T7,T8 = @T8,T9 = @T9,T10 = @T10,SLBH = @SLBH,MBPJ = @MBPJ,SSYPJ = @SSYPJ,SZYPJ = @SZYPJ,PXPJ = @PXPJ,SLPJ = @SLPJ,XJH = @XJH,YYPJB = @YYPJB,TJSY = @TJSY,MB1 = @MB1,MB2 = @MB2,MB3 = @MB3,TJFS = @TJFS,TJPJ = @TJPJ,YYPJH = @YYPJH,XMPY = @XMPY,HXP = @HXP,HXPPJ = @HXPPJ,EB = @EB,YB = @YB,TB = @TB,JB = @JB,PF = @PF,JZX = @JZX,LBJ = @LBJ,JHJS = @JHJS,GBZAM = @GBZAM,DHSA = @DHSA,DHSZ = @DHSZ,GG = @GG,BMKT = @BMKT,YGHKT = @YGHKT,YGEKY = @YGEKY,YGEKT = @YGEKT,BLOOD = @BLOOD,YW = @YW,TW = @TW,CXBH = @CXBH,LJSL = @LJSL,RJSL = @RJSL,JMY = @JMY,WGFB = @WGFB,YYB = @YYB,PEI = @PEI,LSLS = @LSLS,RSLS = @RSLS,LJSLS = @LJSLS,RJSLS = @RJSLS,RTL = @RTL,WSZQ = @WSZQ,RS = @RS,BXP = @BXP,XXB = @XXB,SFZH = @SFZH,DH = @DH,ADDRESS2 = @ADDRESS2,RXYFJZS = @RXYFJZS,YMA = @YMA,YMAJY = @YMAJY,YMB = @YMB,YMBJY = @YMBJY,YMC = @YMC,YMCJY = @YMCJY,YMD = @YMD,YMDJY = @YMDJY,YME = @YME,YMEJY = @YMEJY,YMQT = @YMQT,RXHJZS = @RXHJZS,JWBS = @JWBS,QCQFY = @QCQFY,STUDGUID = @STUDGUID,SCHOOLID = @SCHOOLID,STUDNUM = @STUDNUM,YMF = @YMF,YMFJY = @YMFJY where TJND6 = @TJND6";
            SqlParameter[] sp = new SqlParameter[]
            {       
				new SqlParameter("@TJND6",hw_result2013.TJND),
				new SqlParameter("@BH",hw_result2013.BH),
				new SqlParameter("@CHECKID",hw_result2013.CHECKID),
				new SqlParameter("@SCHOOLBH",hw_result2013.SCHOOLBH),
				new SqlParameter("@GRADEBH4",hw_result2013.GRADEBH),
				new SqlParameter("@CLASSBH2",hw_result2013.CLASSBH),
				new SqlParameter("@RXSJ",hw_result2013.RXSJ),
				new SqlParameter("@XH",hw_result2013.XH),
				new SqlParameter("@SCHOOL_NAME",hw_result2013.SCHOOL_NAME),
				new SqlParameter("@GRADE_NAME",hw_result2013.GRADE_NAME),
				new SqlParameter("@CLASS_NAME",hw_result2013.CLASS_NAME),
				new SqlParameter("@XM",hw_result2013.XM),
				new SqlParameter("@XB",hw_result2013.XB),
				new SqlParameter("@CSRQ",hw_result2013.CSRQ),
				new SqlParameter("@MZ",hw_result2013.MZ),
				new SqlParameter("@ZZMM",hw_result2013.ZZMM),
				new SqlParameter("@SY",hw_result2013.SY),
				new SqlParameter("@TJRQ",hw_result2013.TJRQ),
				new SqlParameter("@NL",hw_result2013.NL),
				new SqlParameter("@MARK",hw_result2013.MARK),
				new SqlParameter("@SG",hw_result2013.SG),
				new SqlParameter("@SGDJQ",hw_result2013.SGDJQ),
				new SqlParameter("@SGDJD",hw_result2013.SGDJD),
				new SqlParameter("@SGBJ",hw_result2013.SGBJ),
				new SqlParameter("@TZ",hw_result2013.TZ),
				new SqlParameter("@TZDJQ",hw_result2013.TZDJQ),
				new SqlParameter("@TZDJD",hw_result2013.TZDJD),
				new SqlParameter("@TZBJ",hw_result2013.TZBJ),
				new SqlParameter("@YYPJ",hw_result2013.YYPJ),
				new SqlParameter("@YYPJX",hw_result2013.YYPJX),
				new SqlParameter("@TXPJ",hw_result2013.TXPJ),
				new SqlParameter("@FYPJ",hw_result2013.FYPJ),
				new SqlParameter("@XW",hw_result2013.XW),
				new SqlParameter("@XWDJQ",hw_result2013.XWDJQ),
				new SqlParameter("@XWDJD",hw_result2013.XWDJD),
				new SqlParameter("@XWBJ",hw_result2013.XWBJ),
				new SqlParameter("@FHL",hw_result2013.FHL),
				new SqlParameter("@FHLDJQ",hw_result2013.FHLDJQ),
				new SqlParameter("@FHLDJD",hw_result2013.FHLDJD),
				new SqlParameter("@FHLBJ",hw_result2013.FHLBJ),
				new SqlParameter("@WL",hw_result2013.WL),
				new SqlParameter("@WLDJQ",hw_result2013.WLDJQ),
				new SqlParameter("@WLDJD",hw_result2013.WLDJD),
				new SqlParameter("@WLBJ",hw_result2013.WLBJ),
				new SqlParameter("@MB",hw_result2013.MB),
				new SqlParameter("@MBBJ",hw_result2013.MBBJ),
				new SqlParameter("@SSY",hw_result2013.SSY),
				new SqlParameter("@SSYBJ",hw_result2013.SSYBJ),
				new SqlParameter("@SZY",hw_result2013.SZY),
				new SqlParameter("@SZYBJ",hw_result2013.SZYBJ),
				new SqlParameter("@LSL",hw_result2013.LSL),
				new SqlParameter("@RSL",hw_result2013.RSL),
				new SqlParameter("@QTYB",hw_result2013.QTYB),
				new SqlParameter("@LQG",hw_result2013.LQG),
				new SqlParameter("@RQG",hw_result2013.RQG),
				new SqlParameter("@LSY",hw_result2013.LSY),
				new SqlParameter("@RSY",hw_result2013.RSY),
				new SqlParameter("@BS",hw_result2013.BS),
				new SqlParameter("@TL",hw_result2013.TL),
				new SqlParameter("@XJ",hw_result2013.XJ),
				new SqlParameter("@BB",hw_result2013.BB),
				new SqlParameter("@QSBNUM",hw_result2013.QSBNUM),
				new SqlParameter("@RQB",hw_result2013.RQB),
				new SqlParameter("@RQS",hw_result2013.RQS),
				new SqlParameter("@RQH",hw_result2013.RQH),
				new SqlParameter("@HQB",hw_result2013.HQB),
				new SqlParameter("@HQS",hw_result2013.HQS),
				new SqlParameter("@HQH",hw_result2013.HQH),
				new SqlParameter("@YZB",hw_result2013.YZB),
				new SqlParameter("@BTT",hw_result2013.BTT),
				new SqlParameter("@XK",hw_result2013.XK),
				new SqlParameter("@JZ",hw_result2013.JZ),
				new SqlParameter("@SZ",hw_result2013.SZ),
				new SqlParameter("@PZ",hw_result2013.PZ),
				new SqlParameter("@XZ",hw_result2013.XZ),
				new SqlParameter("@GP",hw_result2013.GP),
				new SqlParameter("@FEI",hw_result2013.FEI),
				new SqlParameter("@XT",hw_result2013.XT),
				new SqlParameter("@XHDB",hw_result2013.XHDB),
				new SqlParameter("@FHCL",hw_result2013.FHCL),
				new SqlParameter("@PFB",hw_result2013.PFB),
				new SqlParameter("@ZG",hw_result2013.ZG),
				new SqlParameter("@ZGDJQ",hw_result2013.ZGDJQ),
				new SqlParameter("@ZGDJD",hw_result2013.ZGDJD),
				new SqlParameter("@ZGBJ",hw_result2013.ZGBJ),
				new SqlParameter("@JK",hw_result2013.JK),
				new SqlParameter("@JKDJQ",hw_result2013.JKDJQ),
				new SqlParameter("@JKDJD",hw_result2013.JKDJD),
				new SqlParameter("@JKBJ",hw_result2013.JKBJ),
				new SqlParameter("@GPK",hw_result2013.GPK),
				new SqlParameter("@GPKDJQ",hw_result2013.GPKDJQ),
				new SqlParameter("@GPKDJD",hw_result2013.GPKDJD),
				new SqlParameter("@GPKBJ",hw_result2013.GPKBJ),
				new SqlParameter("@BJL",hw_result2013.BJL),
				new SqlParameter("@GSTJ",hw_result2013.GSTJ),
				new SqlParameter("@JJX",hw_result2013.JJX),
				new SqlParameter("@BMKY",hw_result2013.BMKY),
				new SqlParameter("@SJSR",hw_result2013.SJSR),
				new SqlParameter("@WSM",hw_result2013.WSM),
				new SqlParameter("@WSMDJQ",hw_result2013.WSMDJQ),
				new SqlParameter("@WSMDJD",hw_result2013.WSMDJD),
				new SqlParameter("@WSMBJ",hw_result2013.WSMBJ),
				new SqlParameter("@LDTY",hw_result2013.LDTY),
				new SqlParameter("@LDTYDJQ",hw_result2013.LDTYDJQ),
				new SqlParameter("@LDTYDJD",hw_result2013.LDTYDJD),
				new SqlParameter("@LDTYBJ",hw_result2013.LDTYBJ),
				new SqlParameter("@LL",hw_result2013.LL),
				new SqlParameter("@LLDJQ",hw_result2013.LLDJQ),
				new SqlParameter("@LLDJD",hw_result2013.LLDJD),
				new SqlParameter("@LLBJ",hw_result2013.LLBJ),
				new SqlParameter("@NNL",hw_result2013.NNL),
				new SqlParameter("@NNLDJQ",hw_result2013.NNLDJQ),
				new SqlParameter("@NNLDJD",hw_result2013.NNLDJD),
				new SqlParameter("@NNLBJ",hw_result2013.NNLBJ),
				new SqlParameter("@ZWT",hw_result2013.ZWT),
				new SqlParameter("@ZWTDJQ",hw_result2013.ZWTDJQ),
				new SqlParameter("@ZWTDJD",hw_result2013.ZWTDJD),
				new SqlParameter("@ZWTBJ",hw_result2013.ZWTBJ),
				new SqlParameter("@T1",hw_result2013.T1),
				new SqlParameter("@T2",hw_result2013.T2),
				new SqlParameter("@T3",hw_result2013.T3),
				new SqlParameter("@T4",hw_result2013.T4),
				new SqlParameter("@T5",hw_result2013.T5),
				new SqlParameter("@T6",hw_result2013.T6),
				new SqlParameter("@T7",hw_result2013.T7),
				new SqlParameter("@T8",hw_result2013.T8),
				new SqlParameter("@T9",hw_result2013.T9),
				new SqlParameter("@T10",hw_result2013.T10),
				new SqlParameter("@SLBH",hw_result2013.SLBH),
				new SqlParameter("@MBPJ",hw_result2013.MBPJ),
				new SqlParameter("@SSYPJ",hw_result2013.SSYPJ),
				new SqlParameter("@SZYPJ",hw_result2013.SZYPJ),
				new SqlParameter("@PXPJ",hw_result2013.PXPJ),
				new SqlParameter("@SLPJ",hw_result2013.SLPJ),
				new SqlParameter("@XJH",hw_result2013.XJH),
				new SqlParameter("@YYPJB",hw_result2013.YYPJB),
				new SqlParameter("@TJSY",hw_result2013.TJSY),
				new SqlParameter("@MB1",hw_result2013.MB1),
				new SqlParameter("@MB2",hw_result2013.MB2),
				new SqlParameter("@MB3",hw_result2013.MB3),
				new SqlParameter("@TJFS",hw_result2013.TJFS),
				new SqlParameter("@TJPJ",hw_result2013.TJPJ),
				new SqlParameter("@YYPJH",hw_result2013.YYPJH),
				new SqlParameter("@XMPY",hw_result2013.XMPY),
				new SqlParameter("@HXP",hw_result2013.HXP),
				new SqlParameter("@HXPPJ",hw_result2013.HXPPJ),
				new SqlParameter("@EB",hw_result2013.EB),
				new SqlParameter("@YB",hw_result2013.YB),
				new SqlParameter("@TB",hw_result2013.TB),
				new SqlParameter("@JB",hw_result2013.JB),
				new SqlParameter("@PF",hw_result2013.PF),
				new SqlParameter("@JZX",hw_result2013.JZX),
				new SqlParameter("@LBJ",hw_result2013.LBJ),
				new SqlParameter("@JHJS",hw_result2013.JHJS),
				new SqlParameter("@GBZAM",hw_result2013.GBZAM),
				new SqlParameter("@DHSA",hw_result2013.DHSA),
				new SqlParameter("@DHSZ",hw_result2013.DHSZ),
				new SqlParameter("@GG",hw_result2013.GG),
				new SqlParameter("@BMKT",hw_result2013.BMKT),
				new SqlParameter("@YGHKT",hw_result2013.YGHKT),
				new SqlParameter("@YGEKY",hw_result2013.YGEKY),
				new SqlParameter("@YGEKT",hw_result2013.YGEKT),
				new SqlParameter("@BLOOD",hw_result2013.BLOOD),
				new SqlParameter("@YW",hw_result2013.YW),
				new SqlParameter("@TW",hw_result2013.TW),
				new SqlParameter("@CXBH",hw_result2013.CXBH),
				new SqlParameter("@LJSL",hw_result2013.LJSL),
				new SqlParameter("@RJSL",hw_result2013.RJSL),
				new SqlParameter("@JMY",hw_result2013.JMY),
				new SqlParameter("@WGFB",hw_result2013.WGFB),
				new SqlParameter("@YYB",hw_result2013.YYB),
				new SqlParameter("@PEI",hw_result2013.PEI),
				new SqlParameter("@LSLS",hw_result2013.LSLS),
				new SqlParameter("@RSLS",hw_result2013.RSLS),
				new SqlParameter("@LJSLS",hw_result2013.LJSLS),
				new SqlParameter("@RJSLS",hw_result2013.RJSLS),
				new SqlParameter("@RTL",hw_result2013.RTL),
				new SqlParameter("@WSZQ",hw_result2013.WSZQ),
				new SqlParameter("@RS",hw_result2013.RS),
				new SqlParameter("@BXP",hw_result2013.BXP),
				new SqlParameter("@XXB",hw_result2013.XXB),
				new SqlParameter("@SFZH",hw_result2013.SFZH),
				new SqlParameter("@DH",hw_result2013.DH),
				new SqlParameter("@ADDRESS2",hw_result2013.ADDRESS2),
				new SqlParameter("@RXYFJZS",hw_result2013.RXYFJZS),
				new SqlParameter("@YMA",hw_result2013.YMA),
				new SqlParameter("@YMAJY",hw_result2013.YMAJY),
				new SqlParameter("@YMB",hw_result2013.YMB),
				new SqlParameter("@YMBJY",hw_result2013.YMBJY),
				new SqlParameter("@YMC",hw_result2013.YMC),
				new SqlParameter("@YMCJY",hw_result2013.YMCJY),
				new SqlParameter("@YMD",hw_result2013.YMD),
				new SqlParameter("@YMDJY",hw_result2013.YMDJY),
				new SqlParameter("@YME",hw_result2013.YME),
				new SqlParameter("@YMEJY",hw_result2013.YMEJY),
				new SqlParameter("@YMQT",hw_result2013.YMQT),
				new SqlParameter("@RXHJZS",hw_result2013.RXHJZS),
				new SqlParameter("@JWBS",hw_result2013.JWBS),
				new SqlParameter("@QCQFY",hw_result2013.QCQFY),
				new SqlParameter("@STUDGUID",hw_result2013.STUDGUID),
				new SqlParameter("@SCHOOLID",hw_result2013.SCHOOLID),
				new SqlParameter("@STUDNUM",hw_result2013.STUDNUM),
				new SqlParameter("@YMF",hw_result2013.YMF),
				new SqlParameter("@YMFJY",hw_result2013.YMFJY)
            };
            result = SqlHelper.ExecuteNonQuery(WebConn.connString,CommandType.Text,sql,sp);
            return result;
        }
         /// <summary>
        /// 功能：修改HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public int ModHW_Result2013(SqlTransaction transaction,HW_Result2013 hw_result2013)
        {
            int result = 0;
            string sql = "update HW_Result2013 set TJND6 = @TJND6,BH = @BH,CHECKID = @CHECKID,SCHOOLBH = @SCHOOLBH,GRADEBH4 = @GRADEBH4,CLASSBH2 = @CLASSBH2,RXSJ = @RXSJ,XH = @XH,SCHOOL_NAME = @SCHOOL_NAME,GRADE_NAME = @GRADE_NAME,CLASS_NAME = @CLASS_NAME,XM = @XM,XB = @XB,CSRQ = @CSRQ,MZ = @MZ,ZZMM = @ZZMM,SY = @SY,TJRQ = @TJRQ,NL = @NL,MARK = @MARK,SG = @SG,SGDJQ = @SGDJQ,SGDJD = @SGDJD,SGBJ = @SGBJ,TZ = @TZ,TZDJQ = @TZDJQ,TZDJD = @TZDJD,TZBJ = @TZBJ,YYPJ = @YYPJ,YYPJX = @YYPJX,TXPJ = @TXPJ,FYPJ = @FYPJ,XW = @XW,XWDJQ = @XWDJQ,XWDJD = @XWDJD,XWBJ = @XWBJ,FHL = @FHL,FHLDJQ = @FHLDJQ,FHLDJD = @FHLDJD,FHLBJ = @FHLBJ,WL = @WL,WLDJQ = @WLDJQ,WLDJD = @WLDJD,WLBJ = @WLBJ,MB = @MB,MBBJ = @MBBJ,SSY = @SSY,SSYBJ = @SSYBJ,SZY = @SZY,SZYBJ = @SZYBJ,LSL = @LSL,RSL = @RSL,QTYB = @QTYB,LQG = @LQG,RQG = @RQG,LSY = @LSY,RSY = @RSY,BS = @BS,TL = @TL,XJ = @XJ,BB = @BB,QSBNUM = @QSBNUM,RQB = @RQB,RQS = @RQS,RQH = @RQH,HQB = @HQB,HQS = @HQS,HQH = @HQH,YZB = @YZB,BTT = @BTT,XK = @XK,JZ = @JZ,SZ = @SZ,PZ = @PZ,XZ = @XZ,GP = @GP,FEI = @FEI,XT = @XT,XHDB = @XHDB,FHCL = @FHCL,PFB = @PFB,ZG = @ZG,ZGDJQ = @ZGDJQ,ZGDJD = @ZGDJD,ZGBJ = @ZGBJ,JK = @JK,JKDJQ = @JKDJQ,JKDJD = @JKDJD,JKBJ = @JKBJ,GPK = @GPK,GPKDJQ = @GPKDJQ,GPKDJD = @GPKDJD,GPKBJ = @GPKBJ,BJL = @BJL,GSTJ = @GSTJ,JJX = @JJX,BMKY = @BMKY,SJSR = @SJSR,WSM = @WSM,WSMDJQ = @WSMDJQ,WSMDJD = @WSMDJD,WSMBJ = @WSMBJ,LDTY = @LDTY,LDTYDJQ = @LDTYDJQ,LDTYDJD = @LDTYDJD,LDTYBJ = @LDTYBJ,LL = @LL,LLDJQ = @LLDJQ,LLDJD = @LLDJD,LLBJ = @LLBJ,NNL = @NNL,NNLDJQ = @NNLDJQ,NNLDJD = @NNLDJD,NNLBJ = @NNLBJ,ZWT = @ZWT,ZWTDJQ = @ZWTDJQ,ZWTDJD = @ZWTDJD,ZWTBJ = @ZWTBJ,T1 = @T1,T2 = @T2,T3 = @T3,T4 = @T4,T5 = @T5,T6 = @T6,T7 = @T7,T8 = @T8,T9 = @T9,T10 = @T10,SLBH = @SLBH,MBPJ = @MBPJ,SSYPJ = @SSYPJ,SZYPJ = @SZYPJ,PXPJ = @PXPJ,SLPJ = @SLPJ,XJH = @XJH,YYPJB = @YYPJB,TJSY = @TJSY,MB1 = @MB1,MB2 = @MB2,MB3 = @MB3,TJFS = @TJFS,TJPJ = @TJPJ,YYPJH = @YYPJH,XMPY = @XMPY,HXP = @HXP,HXPPJ = @HXPPJ,EB = @EB,YB = @YB,TB = @TB,JB = @JB,PF = @PF,JZX = @JZX,LBJ = @LBJ,JHJS = @JHJS,GBZAM = @GBZAM,DHSA = @DHSA,DHSZ = @DHSZ,GG = @GG,BMKT = @BMKT,YGHKT = @YGHKT,YGEKY = @YGEKY,YGEKT = @YGEKT,BLOOD = @BLOOD,YW = @YW,TW = @TW,CXBH = @CXBH,LJSL = @LJSL,RJSL = @RJSL,JMY = @JMY,WGFB = @WGFB,YYB = @YYB,PEI = @PEI,LSLS = @LSLS,RSLS = @RSLS,LJSLS = @LJSLS,RJSLS = @RJSLS,RTL = @RTL,WSZQ = @WSZQ,RS = @RS,BXP = @BXP,XXB = @XXB,SFZH = @SFZH,DH = @DH,ADDRESS2 = @ADDRESS2,RXYFJZS = @RXYFJZS,YMA = @YMA,YMAJY = @YMAJY,YMB = @YMB,YMBJY = @YMBJY,YMC = @YMC,YMCJY = @YMCJY,YMD = @YMD,YMDJY = @YMDJY,YME = @YME,YMEJY = @YMEJY,YMQT = @YMQT,RXHJZS = @RXHJZS,JWBS = @JWBS,QCQFY = @QCQFY,STUDGUID = @STUDGUID,SCHOOLID = @SCHOOLID,STUDNUM = @STUDNUM,YMF = @YMF,YMFJY = @YMFJY where TJND6 = @TJND6";
            SqlParameter[] sp = new SqlParameter[]
            {       
				new SqlParameter("@TJND6",hw_result2013.TJND),
				new SqlParameter("@BH",hw_result2013.BH),
				new SqlParameter("@CHECKID",hw_result2013.CHECKID),
				new SqlParameter("@SCHOOLBH",hw_result2013.SCHOOLBH),
				new SqlParameter("@GRADEBH4",hw_result2013.GRADEBH),
				new SqlParameter("@CLASSBH2",hw_result2013.CLASSBH),
				new SqlParameter("@RXSJ",hw_result2013.RXSJ),
				new SqlParameter("@XH",hw_result2013.XH),
				new SqlParameter("@SCHOOL_NAME",hw_result2013.SCHOOL_NAME),
				new SqlParameter("@GRADE_NAME",hw_result2013.GRADE_NAME),
				new SqlParameter("@CLASS_NAME",hw_result2013.CLASS_NAME),
				new SqlParameter("@XM",hw_result2013.XM),
				new SqlParameter("@XB",hw_result2013.XB),
				new SqlParameter("@CSRQ",hw_result2013.CSRQ),
				new SqlParameter("@MZ",hw_result2013.MZ),
				new SqlParameter("@ZZMM",hw_result2013.ZZMM),
				new SqlParameter("@SY",hw_result2013.SY),
				new SqlParameter("@TJRQ",hw_result2013.TJRQ),
				new SqlParameter("@NL",hw_result2013.NL),
				new SqlParameter("@MARK",hw_result2013.MARK),
				new SqlParameter("@SG",hw_result2013.SG),
				new SqlParameter("@SGDJQ",hw_result2013.SGDJQ),
				new SqlParameter("@SGDJD",hw_result2013.SGDJD),
				new SqlParameter("@SGBJ",hw_result2013.SGBJ),
				new SqlParameter("@TZ",hw_result2013.TZ),
				new SqlParameter("@TZDJQ",hw_result2013.TZDJQ),
				new SqlParameter("@TZDJD",hw_result2013.TZDJD),
				new SqlParameter("@TZBJ",hw_result2013.TZBJ),
				new SqlParameter("@YYPJ",hw_result2013.YYPJ),
				new SqlParameter("@YYPJX",hw_result2013.YYPJX),
				new SqlParameter("@TXPJ",hw_result2013.TXPJ),
				new SqlParameter("@FYPJ",hw_result2013.FYPJ),
				new SqlParameter("@XW",hw_result2013.XW),
				new SqlParameter("@XWDJQ",hw_result2013.XWDJQ),
				new SqlParameter("@XWDJD",hw_result2013.XWDJD),
				new SqlParameter("@XWBJ",hw_result2013.XWBJ),
				new SqlParameter("@FHL",hw_result2013.FHL),
				new SqlParameter("@FHLDJQ",hw_result2013.FHLDJQ),
				new SqlParameter("@FHLDJD",hw_result2013.FHLDJD),
				new SqlParameter("@FHLBJ",hw_result2013.FHLBJ),
				new SqlParameter("@WL",hw_result2013.WL),
				new SqlParameter("@WLDJQ",hw_result2013.WLDJQ),
				new SqlParameter("@WLDJD",hw_result2013.WLDJD),
				new SqlParameter("@WLBJ",hw_result2013.WLBJ),
				new SqlParameter("@MB",hw_result2013.MB),
				new SqlParameter("@MBBJ",hw_result2013.MBBJ),
				new SqlParameter("@SSY",hw_result2013.SSY),
				new SqlParameter("@SSYBJ",hw_result2013.SSYBJ),
				new SqlParameter("@SZY",hw_result2013.SZY),
				new SqlParameter("@SZYBJ",hw_result2013.SZYBJ),
				new SqlParameter("@LSL",hw_result2013.LSL),
				new SqlParameter("@RSL",hw_result2013.RSL),
				new SqlParameter("@QTYB",hw_result2013.QTYB),
				new SqlParameter("@LQG",hw_result2013.LQG),
				new SqlParameter("@RQG",hw_result2013.RQG),
				new SqlParameter("@LSY",hw_result2013.LSY),
				new SqlParameter("@RSY",hw_result2013.RSY),
				new SqlParameter("@BS",hw_result2013.BS),
				new SqlParameter("@TL",hw_result2013.TL),
				new SqlParameter("@XJ",hw_result2013.XJ),
				new SqlParameter("@BB",hw_result2013.BB),
				new SqlParameter("@QSBNUM",hw_result2013.QSBNUM),
				new SqlParameter("@RQB",hw_result2013.RQB),
				new SqlParameter("@RQS",hw_result2013.RQS),
				new SqlParameter("@RQH",hw_result2013.RQH),
				new SqlParameter("@HQB",hw_result2013.HQB),
				new SqlParameter("@HQS",hw_result2013.HQS),
				new SqlParameter("@HQH",hw_result2013.HQH),
				new SqlParameter("@YZB",hw_result2013.YZB),
				new SqlParameter("@BTT",hw_result2013.BTT),
				new SqlParameter("@XK",hw_result2013.XK),
				new SqlParameter("@JZ",hw_result2013.JZ),
				new SqlParameter("@SZ",hw_result2013.SZ),
				new SqlParameter("@PZ",hw_result2013.PZ),
				new SqlParameter("@XZ",hw_result2013.XZ),
				new SqlParameter("@GP",hw_result2013.GP),
				new SqlParameter("@FEI",hw_result2013.FEI),
				new SqlParameter("@XT",hw_result2013.XT),
				new SqlParameter("@XHDB",hw_result2013.XHDB),
				new SqlParameter("@FHCL",hw_result2013.FHCL),
				new SqlParameter("@PFB",hw_result2013.PFB),
				new SqlParameter("@ZG",hw_result2013.ZG),
				new SqlParameter("@ZGDJQ",hw_result2013.ZGDJQ),
				new SqlParameter("@ZGDJD",hw_result2013.ZGDJD),
				new SqlParameter("@ZGBJ",hw_result2013.ZGBJ),
				new SqlParameter("@JK",hw_result2013.JK),
				new SqlParameter("@JKDJQ",hw_result2013.JKDJQ),
				new SqlParameter("@JKDJD",hw_result2013.JKDJD),
				new SqlParameter("@JKBJ",hw_result2013.JKBJ),
				new SqlParameter("@GPK",hw_result2013.GPK),
				new SqlParameter("@GPKDJQ",hw_result2013.GPKDJQ),
				new SqlParameter("@GPKDJD",hw_result2013.GPKDJD),
				new SqlParameter("@GPKBJ",hw_result2013.GPKBJ),
				new SqlParameter("@BJL",hw_result2013.BJL),
				new SqlParameter("@GSTJ",hw_result2013.GSTJ),
				new SqlParameter("@JJX",hw_result2013.JJX),
				new SqlParameter("@BMKY",hw_result2013.BMKY),
				new SqlParameter("@SJSR",hw_result2013.SJSR),
				new SqlParameter("@WSM",hw_result2013.WSM),
				new SqlParameter("@WSMDJQ",hw_result2013.WSMDJQ),
				new SqlParameter("@WSMDJD",hw_result2013.WSMDJD),
				new SqlParameter("@WSMBJ",hw_result2013.WSMBJ),
				new SqlParameter("@LDTY",hw_result2013.LDTY),
				new SqlParameter("@LDTYDJQ",hw_result2013.LDTYDJQ),
				new SqlParameter("@LDTYDJD",hw_result2013.LDTYDJD),
				new SqlParameter("@LDTYBJ",hw_result2013.LDTYBJ),
				new SqlParameter("@LL",hw_result2013.LL),
				new SqlParameter("@LLDJQ",hw_result2013.LLDJQ),
				new SqlParameter("@LLDJD",hw_result2013.LLDJD),
				new SqlParameter("@LLBJ",hw_result2013.LLBJ),
				new SqlParameter("@NNL",hw_result2013.NNL),
				new SqlParameter("@NNLDJQ",hw_result2013.NNLDJQ),
				new SqlParameter("@NNLDJD",hw_result2013.NNLDJD),
				new SqlParameter("@NNLBJ",hw_result2013.NNLBJ),
				new SqlParameter("@ZWT",hw_result2013.ZWT),
				new SqlParameter("@ZWTDJQ",hw_result2013.ZWTDJQ),
				new SqlParameter("@ZWTDJD",hw_result2013.ZWTDJD),
				new SqlParameter("@ZWTBJ",hw_result2013.ZWTBJ),
				new SqlParameter("@T1",hw_result2013.T1),
				new SqlParameter("@T2",hw_result2013.T2),
				new SqlParameter("@T3",hw_result2013.T3),
				new SqlParameter("@T4",hw_result2013.T4),
				new SqlParameter("@T5",hw_result2013.T5),
				new SqlParameter("@T6",hw_result2013.T6),
				new SqlParameter("@T7",hw_result2013.T7),
				new SqlParameter("@T8",hw_result2013.T8),
				new SqlParameter("@T9",hw_result2013.T9),
				new SqlParameter("@T10",hw_result2013.T10),
				new SqlParameter("@SLBH",hw_result2013.SLBH),
				new SqlParameter("@MBPJ",hw_result2013.MBPJ),
				new SqlParameter("@SSYPJ",hw_result2013.SSYPJ),
				new SqlParameter("@SZYPJ",hw_result2013.SZYPJ),
				new SqlParameter("@PXPJ",hw_result2013.PXPJ),
				new SqlParameter("@SLPJ",hw_result2013.SLPJ),
				new SqlParameter("@XJH",hw_result2013.XJH),
				new SqlParameter("@YYPJB",hw_result2013.YYPJB),
				new SqlParameter("@TJSY",hw_result2013.TJSY),
				new SqlParameter("@MB1",hw_result2013.MB1),
				new SqlParameter("@MB2",hw_result2013.MB2),
				new SqlParameter("@MB3",hw_result2013.MB3),
				new SqlParameter("@TJFS",hw_result2013.TJFS),
				new SqlParameter("@TJPJ",hw_result2013.TJPJ),
				new SqlParameter("@YYPJH",hw_result2013.YYPJH),
				new SqlParameter("@XMPY",hw_result2013.XMPY),
				new SqlParameter("@HXP",hw_result2013.HXP),
				new SqlParameter("@HXPPJ",hw_result2013.HXPPJ),
				new SqlParameter("@EB",hw_result2013.EB),
				new SqlParameter("@YB",hw_result2013.YB),
				new SqlParameter("@TB",hw_result2013.TB),
				new SqlParameter("@JB",hw_result2013.JB),
				new SqlParameter("@PF",hw_result2013.PF),
				new SqlParameter("@JZX",hw_result2013.JZX),
				new SqlParameter("@LBJ",hw_result2013.LBJ),
				new SqlParameter("@JHJS",hw_result2013.JHJS),
				new SqlParameter("@GBZAM",hw_result2013.GBZAM),
				new SqlParameter("@DHSA",hw_result2013.DHSA),
				new SqlParameter("@DHSZ",hw_result2013.DHSZ),
				new SqlParameter("@GG",hw_result2013.GG),
				new SqlParameter("@BMKT",hw_result2013.BMKT),
				new SqlParameter("@YGHKT",hw_result2013.YGHKT),
				new SqlParameter("@YGEKY",hw_result2013.YGEKY),
				new SqlParameter("@YGEKT",hw_result2013.YGEKT),
				new SqlParameter("@BLOOD",hw_result2013.BLOOD),
				new SqlParameter("@YW",hw_result2013.YW),
				new SqlParameter("@TW",hw_result2013.TW),
				new SqlParameter("@CXBH",hw_result2013.CXBH),
				new SqlParameter("@LJSL",hw_result2013.LJSL),
				new SqlParameter("@RJSL",hw_result2013.RJSL),
				new SqlParameter("@JMY",hw_result2013.JMY),
				new SqlParameter("@WGFB",hw_result2013.WGFB),
				new SqlParameter("@YYB",hw_result2013.YYB),
				new SqlParameter("@PEI",hw_result2013.PEI),
				new SqlParameter("@LSLS",hw_result2013.LSLS),
				new SqlParameter("@RSLS",hw_result2013.RSLS),
				new SqlParameter("@LJSLS",hw_result2013.LJSLS),
				new SqlParameter("@RJSLS",hw_result2013.RJSLS),
				new SqlParameter("@RTL",hw_result2013.RTL),
				new SqlParameter("@WSZQ",hw_result2013.WSZQ),
				new SqlParameter("@RS",hw_result2013.RS),
				new SqlParameter("@BXP",hw_result2013.BXP),
				new SqlParameter("@XXB",hw_result2013.XXB),
				new SqlParameter("@SFZH",hw_result2013.SFZH),
				new SqlParameter("@DH",hw_result2013.DH),
				new SqlParameter("@ADDRESS2",hw_result2013.ADDRESS2),
				new SqlParameter("@RXYFJZS",hw_result2013.RXYFJZS),
				new SqlParameter("@YMA",hw_result2013.YMA),
				new SqlParameter("@YMAJY",hw_result2013.YMAJY),
				new SqlParameter("@YMB",hw_result2013.YMB),
				new SqlParameter("@YMBJY",hw_result2013.YMBJY),
				new SqlParameter("@YMC",hw_result2013.YMC),
				new SqlParameter("@YMCJY",hw_result2013.YMCJY),
				new SqlParameter("@YMD",hw_result2013.YMD),
				new SqlParameter("@YMDJY",hw_result2013.YMDJY),
				new SqlParameter("@YME",hw_result2013.YME),
				new SqlParameter("@YMEJY",hw_result2013.YMEJY),
				new SqlParameter("@YMQT",hw_result2013.YMQT),
				new SqlParameter("@RXHJZS",hw_result2013.RXHJZS),
				new SqlParameter("@JWBS",hw_result2013.JWBS),
				new SqlParameter("@QCQFY",hw_result2013.QCQFY),
				new SqlParameter("@STUDGUID",hw_result2013.STUDGUID),
				new SqlParameter("@SCHOOLID",hw_result2013.SCHOOLID),
				new SqlParameter("@STUDNUM",hw_result2013.STUDNUM),
				new SqlParameter("@YMF",hw_result2013.YMF),
				new SqlParameter("@YMFJY",hw_result2013.YMFJY)
            };
            result = SqlHelper.ExecuteNonQuery(transaction,CommandType.Text,sql,sp);
            return result;
        }
        #endregion
		
		#region##统计HW_Result2013
		/// <summary>
        /// 修改HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
		public int SelectCount()
		{
			int i = 0;
            string sql = "select count(*) from HW_Result2013";
            i = (int)SqlHelper.ExecuteScalar(WebConn.connString,CommandType.Text,sql);
            return i;
		}
		/// <summary>
        /// 修改HW_Result2013
        /// 创建人：  Wilson 
        /// 创建时间：2013-1-30
        /// </summary>
        /// <param name=""></param>
        /// <returns></returns>
        public int SelectCountById()
        {
            int i=0;
            string sql="select count(TJND6) from HW_Result2013";
            i = (int)SqlHelper.ExecuteScalar(WebConn.connString,CommandType.Text,sql);
            return i;
        }
		#endregion
        #region##自定义HW_Result2013
        #endregion
                
    }
}
